This week my cohort, DS29, had the challenge of taking on a Snowflake client project. Although this project was internal, it was definitely one of the most challenging projects.

Snowflake is very useful as a cloud-hosted database, because it allows data from an API to be directed into Tableau easily. The 'Lateral Flatten' function in Snowflake is used to parse out the necessary data one might need in order to create fields and rows in a dataset.

The query above shows how the Lateral Flatten is used to parse out fields such as "Beer_Name", "Description", "Alcohol_By_Volume", ect. from an API of JSON data 'PG_Beers_JSON'. These queries were very useful in our project this week.