BankOrg Docs

In progress

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 amounts NUMBER(18,2), interest_rate NUMBER(9,4), timestamps TIMESTAMP_NTZ.
  • _SNAPSHOT_DATE is exposed as snapshot_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, with leg_no and direction (DR or CR) identifying the side of a posting leg, and is_latest_event marking the last event of each side.

The models, tests and the daily job are described in Staging.