skill
CDC and SCD patterns
cdc-scd-patterns
Change data capture with Datastream and slowly changing dimensions (Type 1 and 2) in BigQuery and Dataform.
When to use it
You replicate an operational database or keep history in dimension tables.
Technical description
Guides Change Data Capture (CDC) ingestion via Datastream and Slowly Changing Dimension (SCD) modeling in BigQuery/Dataform. Use when replicating an operational database, designing history-tracking dimension tables, or implementing SCD Type 1/2 merge logic.