BankOrg Docs

In progress

BankOrg Data Platform / Data Modeling

Gold

Interactive physical model of the PRD_GOLD database: the four marts, one per business domain schema, with their grain, columns and types.

PRD_GOLD has one schema per business domain and one mart in each: ACCOUNT.daily_account_balance, TRANSACTION.daily_transaction_summary, BRANCH.branch_performance and CUSTOMER.customer_360. dbt creates them as tables and rebuilds them on every run. The canvas draws the four marts together; pick one in the explorer or on the canvas to see its columns and types.

Banking Data Architecture Explorer

drag tables · scroll to zoom

Grain

The primary key marked on the canvas is the unique combination that dbt tests on each mart. Row counts are from the build of 2026-11-01.

TableGrainRows
ACCOUNT.daily_account_balancebalance_date, branch_code, product_group301,732
TRANSACTION.daily_transaction_summarytransaction_date, branch_code, product_group, transaction_type6,689
BRANCH.branch_performancereport_date, branch_code194,110
CUSTOMER.customer_360customer_id343

Relationships

  • Gold has no foreign key between its tables, because a mart is an aggregate and not an entity. branch_code in every mart points to PRD_SILVER.CORE.dim_branch and customer_id of customer_360 to dim_customer; both are checked by a dbt relationships test, not by a constraint.
  • branch_code is the current branch of the account and branch_name the current name of that branch, so branch_name follows from branch_code and is not part of the grain (ADR 0006).
  • product_group is DEPOSIT or CREDIT; the bank's own accounts (INTERNAL) are not in Gold. A loan balance is negative and is kept in its own row or column, never netted against a deposit.

Types

  • Text columns are VARCHAR, dates DATE. Counts are NUMBER with scale 0 and balances and amounts NUMBER(38,2) (a sum of NUMBER(18,2)); posted_amount is NUMBER(30,2). Snowflake sets the precision of a sum or a count from the type of its input, so the dbt models do not cast them.
  • No column holds PII, so the masking post-hook of Silver is not applied to Gold.

How the marts are built and tested is in Gold; the tables they read are in Silver Core.