DimensionAttributeValueSetItem

-- ============================================================
-- Table  : DimensionAttributeValueSetItem One row per dimension value inside a stored value set — the line level of DimensionAttributeValueSet, carrying the value's display code denormalized for fast decodes
-- Purpose: Column-selected read of DimensionAttributeValueSetItem — auto-generated from field metadata
-- Grain  : One row per DimensionAttributeValueSet + DimensionAttributeValue
-- 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.dimensionattributevalueset AS "RecId of the value set this line belongs to — join from a master's DefaultDimension to explode the set into rows",
  d.dimensionattributevalue AS "RecId of the dimension value on this line — the hop to DimensionAttributeValue and on to DimensionAttribute for the dimension name",
  d.displayvalue AS "The value code stored denormalized on the line — often all a decode needs once you know the dimension",
  d.backingrecorddataareaid AS "Company of the value's backing record, populated for company-specific dimension values"
FROM <catalog>.<schema>.dimensionattributevaluesetitem d
-- Resolve DimensionAttributeValueSet (via DimensionAttributeValueSet): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.dimensionattributevalueset dim ON dim.recid = d.dimensionattributevalueset
-- Resolve DimensionAttributeValue (via DimensionAttributeValue): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.dimensionattributevalue dim ON dim.recid = d.dimensionattributevalue
ORDER BY d.dimensionattributevalueset;