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
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.
| Table | Grain | Rows |
|---|---|---|
| ACCOUNT.daily_account_balance | balance_date, branch_code, product_group | 301,732 |
| TRANSACTION.daily_transaction_summary | transaction_date, branch_code, product_group, transaction_type | 6,689 |
| BRANCH.branch_performance | report_date, branch_code | 194,110 |
| CUSTOMER.customer_360 | customer_id | 343 |
Relationships
- Gold has no foreign key between its tables, because a mart is an aggregate and not an entity.
branch_codein every mart points toPRD_SILVER.CORE.dim_branchandcustomer_idofcustomer_360todim_customer; both are checked by a dbtrelationshipstest, not by a constraint. branch_codeis the current branch of the account andbranch_namethe current name of that branch, sobranch_namefollows frombranch_codeand is not part of the grain (ADR 0006).product_groupis 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, datesDATE. Counts areNUMBERwith scale 0 and balances and amountsNUMBER(38,2)(a sum ofNUMBER(18,2));posted_amountisNUMBER(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.