Senior AI Dev Kit
Back to the catalog

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.