Reference & GlossaryData Reference (for your data team)
Core
The base star schema every DPU client gets.
Core is the base mart — the star schema every DPU deployment gets, built directly on top of the Data Enrichment pipeline's output. It's queryable straight from your Snowflake account; there's no separate export step.
Dimensions
| Table | Grain |
|---|---|
core_dim_date | One row per calendar date |
core_dim_meter | SCD2 — one row per meter per version |
core_dim_customer | SCD2 — one row per contract per version |
core_dim_service_point | Current-state — one row per meter-at-SDP assignment |
core_dim_event_type | Static lookup of meter alarm/event definitions |
Facts
| Table | Grain |
|---|---|
core_fct_interval_reading | One row per interval per SDP/channel |
core_fct_register_reading | One row per register (cumulative) read per SDP/channel |
core_fct_meter_events | One row per meter alarm/outage event occurrence |
core_fct_exceptions | One row per validation exception |
A bridge table, core_int_sdp_occupant, resolves which customer occupied a given service point at any point in time — this is what lets facts join correctly to the right customer even as occupancy changes over time.
The two SCD2 dimensions (core_dim_meter, core_dim_customer) mean history is preserved: a meter swap or a change in contract doesn't overwrite the old record, it versions it.