BankOrg Data Platform / Data Modeling / Silver
Snapshots
Interactive physical model of the PRD_SILVER.SNAPSHOTS schema: the three dbt snapshots with their SCD Type 2 columns and relationships.
PRD_SILVER.SNAPSHOTS holds three tables, snp_branches, snp_customers and snp_accounts. dbt creates them with dbt snapshot over the staging views; no Snowflake script creates the tables. Pick a table in the explorer or on the canvas to see its columns and relationships.
Banking Data Architecture Explorer
drag tables · scroll to zoom
Compared with staging
- Every column of the staging view is kept, with the same types, and dbt adds
dbt_scd_id,dbt_updated_at,dbt_valid_fromanddbt_valid_to. - A business key (
branch_code,customer_id,account_id) can have several rows, one per version. The current version hasdbt_valid_toempty;dbt_scd_idis unique for each version. - A new version opens only when
row_hashchanges. The hash of an account leaves outcurrent_balance. - The PII columns of
snp_customersandaccount_numberofsnp_accountscarry the PII tag, set by a dbt post-hook.
The configuration, the dimensions built from the snapshots and the tests are described in Silver.