BankOrg Data Platform / Data Modeling / Staging
Core Banking
Interactive physical model of the PRD_STAGING.CORE_BANKING schema: the four dbt views, their columns, keys and relationships.
PRD_STAGING.CORE_BANKING holds four views, one per table of PRD_RAW.CORE_BANKING. dbt creates them; no Snowflake script does. Pick a view in the explorer or on the canvas to see its columns, keys and relationships.
Banking Data Architecture Explorer
drag tables · scroll to zoom
Compared with RAW
- Source columns are typed: dates are
DATE, balances and amountsNUMBER(18,2),interest_rateNUMBER(9,4), timestampsTIMESTAMP_NTZ. _SNAPSHOT_DATEis exposed assnapshot_date. The other load metadata columns are kept as they are.- Branches, customers and accounts hold the latest snapshot only, one row per key, with a
row_hash. Transactions hold every change event, withleg_noanddirection(DRorCR) identifying the side of a posting leg, andis_latest_eventmarking the last event of each side.
The models, tests and the daily job are described in Staging.