Designing Idempotent and Reliable Pipelines
Use a business key and source revision to make a destination update safe to replay.
SQL
Notes, examples, and design choices for this topic.
Open this topic in the archive · All topics
Filters and display
3 articles · SQL · All levels · Newest · Page 1/1
Understanding Dimensional Modeling and Star Schemas
Choose a sales fact grain before joining descriptive dimensions and aggregating revenue.
SQL for Cleaning Transaction Data
Normalize missing identifiers, choose a deterministic duplicate winner, and reconcile rejected transactions.