Snowflake is the leading cloud data warehouse platform. Moreover, it is the first data warehouse that was created for the cloud. In this section, we will launch a Snowflake instance and connect to it with Tableau. Currently, Snowflake is available for AWS and Azure. We are going to use the AWS version of Snowflake.
Snowflake has a multi-cluster shared architecture, and it separates storage and computes. This allows it to easily scale up and down on the fly without any disruption.
Snowflake is an SQL data warehouse that supports structured and semi-structured data, such as JSON, AVRO, or XML.
The Snowflake architecture consists of the following three layers:
- Cloud services: This is a collection of services such as authentication, and so on
- Query processing: Snowflake executes queries using a virtual warehouse, for example, an MPP cluster with multiple compute...