Advanced Snowflake

Snowflake architecture

Getting set up with Snowflake

Micropartitioning and clustering

Types of tables in Snowflake

Creating permanent tables

Creating temporary tables

Creating transient tables

Configuring data retention time

Querying historical data

Dropping and restoring tables

Non-materialized, materialized, and secure views

Creating and populating tables

Creating and querying views

Recreating views

Querying regular views and secure views

Creating and querying materialized views

Loading data using COPY INTO

Retrieval optimization using cached results

Enabling clustering on tables

Querying clustered tables

Querying clustering information

Running point lookup queries on search-optimized tables

Clustering vs. search optimization

Loading and querying parquet data

Loading JSON data

Querying JSON data

Access control

Creating users and viewing grants

Granting privileges to roles

Summary and next steps