DimensionAttribute

-- ============================================================
-- Table  : DimensionAttribute The registry of financial dimensions themselves (cost center, department, business unit…) — one row per dimension, recording which table or view backs its values
-- Purpose: Column-selected read of DimensionAttribute — auto-generated from field metadata
-- Grain  : One row per Name
-- Notes  : Auto-generated skeleton for Synapse Link / Fabric Link-landed F&O data (lowercase column names). Enums decoded inline where verified; datetimes stored in UTC; 1900-01-01 dates are sentinels mapped to NULL. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
  d.name AS "The dimension's name (CostCenter, Department, BusinessUnit…) — the natural identifier analysts pivot decoded columns on",
  d.type AS "How the dimension is backed — a custom value list or an entity-backed dimension; values are not decoded here, use the metadata join",  -- enum: decode d.type via GlobalOptionsetMetadata join — see quirks guide #enums
  d.backingentitytype AS "Table ID of the view that supplies this dimension's values",
  d.backingentitytablename AS "Name of the table or view that backs the dimension's values (e.g. the cost-center view for an entity-backed dimension)",
  d.viewname AS "Name of the generated database view that exposes this dimension's values",
  d.reportcolumnname AS "Column name the dimension surfaces under in financial reporting",
  d.recid AS "The 64-bit surrogate key DimensionAttributeValue.DimensionAttribute joins to"
FROM <catalog>.<schema>.dimensionattribute d
ORDER BY d.name;