Partitioning and Clustering: How to Make Warehouse Queries Faster
Data partitioning for faster queries: how partition pruning works, pick partition keys, avoid the small files problem, and when clustering or Z-ordering helps.
WRITING / NOTES FROM THE FORGE
Data Warehouse
4 articles tagged Data Warehouse.
Slowly Changing Dimensions (SCD) Explained: Types 1, 2, and 3
Slowly changing dimensions explained: SCD Type 1, 2, and 3 with a SQL MERGE example, surrogate keys, effective dates, and current flags for accurate history.
Star Schema vs Snowflake Schema: Data Modeling for Analytics
Star schema vs snowflake schema explained with facts, dimensions, grain, SQL examples, and clear guidance on which data model fits your analytics warehouse.
Data Warehouse vs Data Lake vs Lakehouse: Which Do You Need?
Data warehouse vs data lake vs lakehouse compared: storage, schema, cost, and open table formats like Iceberg and Delta Lake, with guidance on what to pick.