Snowflake concepts and Fundamentals (Only Theory) [2020]

Explore the compute layer, also called the bathhouse, as the access point to storage, learn how independent virtual warehouses scale in size and auto suspend when idle with credits-based pricing.

Discover how the Snowflake service layer acts as the brain of the snowflake, handling authentication, security, metadata, and a result cache to enable fast, partition-aware queries and cross-workload consistency.

Explore Snowflake data stages, including default user and table stages, and named stages that are external or internal, and learn how staging areas prepare data before loading into Snowflake tables.

Explore data load methods in Snowflake: bulk loading with copy from a stage using a user-provisioned warehouse for simple transformations, and continuous loading via snow pipe managed by Snowflake.

Set up a Snowpipe to enable continuous data loading from an S3 bucket into a Snowflake table using event notifications to trigger the copy.

Learn how zero copy clone in Snowflake creates clones of databases, tables, or schemas by referencing the same micro-partition data and using metadata-only operations, enabling instantaneous, file-less cloning.

Explore Snowflake time travel to query data at a specific timestamp or date, using timestamp-based queries and cloning to restore or recreate past states without overhead.

Explore Snowflake's failsafe feature that enables data recovery within seven days, reducing the need for daily backups while highlighting associated storage costs and admin considerations.