Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

Introduction

• Advanced Snowflake
• Snowflake architecture
• Getting set up with Snowflake

1. Table Structures in 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

2. Views in Snowflake

• 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

3. Optimizing Query Performance

• Caching, clustering, and search optimization
• 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

4. Working with Semi-structured Data

• Loading and querying parquet data
• Loading JSON data
• Querying JSON data

5. Managing Users and Granting Privileges

• Access control
• Creating users and viewing grants
• Granting privileges to roles

Conclusion

• Summary and next steps