Data dictionary
Every schema, table and column in the Dax Data Warehouse.
| Layer | Query surface | Internal | Columns |
|---|---|---|---|
| Input Layer | 15 | 0 | 435 |
| Normalized Layer | 20 | 24 | 367 |
| Claims Preprocessing | 153 | 47 | 1485 |
| Core Data Model | 24 | 12 | 684 |
| Data Quality | 35 | 0 | 169 |
| Metadata | 1 | 0 | 9 |
| Parity | 1 | 0 | 3 |
| Total | 249 | 83 | 3152 |
The query surface is the set of tables you are expected to read from. Internal models are intermediate and staging steps kept for lineage and debugging; treat them as implementation detail that may change.
How to read these pages
- Schema and Table are the identifiers to use in SQL.
- Grain lists the columns that uniquely identify one row. Include every grain column in a join, or the result fans out.
- Type is the column's data type as the warehouse declares it.
- Key marks a column that forms part of the primary key.
- Terminology names the value set that governs a coded column, and links to it.
- Constraints are the rules the warehouse enforces on the column.
Terminology
Coded columns are paired with reference value sets that translate a code into a readable description.