Data Architecture Cheat Sheets

Design durable data systems - dimensional modeling, storage architecture, and system-design patterns. These sheets cover the decisions that hurt most when you get them wrong: star vs snowflake, SCD strategy, batch vs streaming, storage vs compute separation.

Data modeling

• Data Modeling Cheat Sheet - star/snowflake schemas, SCD Type 1/2/3, normalization, fact vs dim, Data Vault

Interview-focused architecture sheets

• Snowflake Streams & Tasks (Interview) - change data capture, incremental patterns
• Snowflake Dynamic Tables (Interview) - declarative pipelines, refresh semantics
• Snowflake Iceberg Tables (Interview) - open table format, catalog integrations
• Snowflake Replication & Failover (Interview) - DR patterns, cross-region

Related tools

Use the warehouse sizing tool for capacity planning and the cost calculator for TCO modeling.

Related categories

Explore cloud platform cheat sheets, interview cheat sheets, and the full cheat sheet library.

← Back to Home