Skip to main content
Data Warehouse

Loan Ops ERD

Interactive entity-relationship diagram for the customer-facing Loan Ops data model.

Interactive entity-relationship diagram for the Loan Ops model in the data warehouse (PROD_DATA_EXPLORER_DB.LOAN_OPS). Pan, zoom, search, and click a table to inspect its columns.

The diagram may include a few tables that are still rolling out and not yet available in your warehouse. The Data dictionary lists every table you can query today.

Relationships are inferred from column naming, not enforced — these are Snowflake views with no foreign-key constraints. The *_ID columns are read as references (for example ADVANCE.LOAN_ID points at LOAN), so the edges show the intended join model rather than database-enforced keys.