UnitOfMeasure

-- ============================================================
-- Table  : UnitOfMeasure The shared unit-of-measure master — one row per unit symbol (kg, ea, hr) with its unit class and system of units; every quantity column in the lake ultimately resolves to a symbol here
-- Purpose: Column-selected read of UnitOfMeasure — auto-generated from field metadata
-- Grain  : One row per Symbol
-- 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
  u.symbol AS "The unit symbol (kg, ea, hr) — the natural key, and the value unit columns across the lake resolve to",
  u.unitofmeasureclass AS "Class of the unit (length, mass, quantity, time…) — conversions only exist within or between classes deliberately",  -- enum: decode u.unitofmeasureclass via GlobalOptionsetMetadata join — see quirks guide #enums
  u.systemofunits AS "System of units the unit belongs to (metric, US customary…)",  -- enum: decode u.systemofunits via GlobalOptionsetMetadata join — see quirks guide #enums
  u.decimalprecision AS "Number of decimals quantities in this unit are rounded to",
  u.recid AS "The 64-bit surrogate key UnitOfMeasureConversion joins to on both the from and to side"
FROM <catalog>.<schema>.unitofmeasure u
ORDER BY u.symbol;