Skip to content

Instantly share code, notes, and snippets.

View adityawarmanfw's full-sized avatar

Fidocia Wima Adityawarman adityawarmanfw

View GitHub Profile
@jeremyyeo
jeremyyeo / README.md
Last active September 9, 2024 17:53
Building SCD-2 models using the default incremental materialization #dbt

Building SCD-2 models using the default incremental materialization

  1. Bootstrap the source / snapshot table source_users and the initial state of our scd2 table dim_users by running:
dbt run -m source_users dim_users
  1. Copy over contents of dim_users_inc.sql replacing contents in dim_users.sql (or just rename them). Then run: