BigQuery Architecture and Cost
BigQuery bills what a query reads or the slots it occupies. Work through column, partition, and clustering effects, dry runs, slot time, and the on-demand versus capacity choice.
-
-
Snowflake Architecture and Workload Design
Snowflake writes new files instead of editing old ones. See how that explains result reuse, the warehouse cache, Time Travel recovery, clones, and retention cost.
-
Semantic Layers and Consistent Metric Definitions
One question, “what was March revenue?”, can honestly return 600, 550, or 100 from the same seven orders. This post shows how metric contracts, aggregation rules, time-window rules, versions, and consumer tests make one answer.
-
Dimensional Modeling and Historical Restatement
A customer moves region, a sale arrives late, and a correction shows the move happened earlier. This post shows how a dimensional model attributes facts, restates history on purpose, and proves the totals still agree.
-
Warehouse Workload Isolation and Concurrency
When dashboards wait behind an export, resizing may not help. Learn how compute separation, queues, workload classes, and access controls shape warehouse performance.
-
Partitioning, Compaction, and Table Maintenance
Lakehouse tables degrade through small files, drifting layouts, and old snapshots. See how sizing, pruning, compaction, and expiry work and how to validate their cost.
-
Open Table Formats: Snapshots and Catalogs
A table format decides which files are the table, commits changes atomically, and lets readers keep a consistent snapshot. See how the mechanisms and their limits work.