❄️
SNOWFLAKE
Snowflake for Data Engineers
Architecture, warehouses, RBAC, Snowpipe, Streams, Tasks, Dynamic Tables, Snowpark, Iceberg, data sharing, and optimization.
7 in-depth tutorials
01Snowflake Overview & Architecture
Snowflake architecture: three layers, virtual warehouses, micro-partitions, and pricing model.
Account setup: databases, schemas, warehouses, roles, RBAC, and resource monitors.
Loading data: stages, file formats, COPY INTO, Snowpipe, and continuous ingestion.
Transformations: Streams, Tasks, Dynamic Tables, MERGE, and CDC patterns.
Snowpark Python: DataFrames, UDFs, stored procedures, pandas on Snowflake, and ML.
Iceberg tables, data sharing, zero-copy cloning, Time Travel, and the open lakehouse.
07Performance & Cost Optimization
Performance optimization: clustering keys, caching layers, Query Profile, and cost control.