AI Azure Synapse schema generator

CREATE TABLE analytics.dim_customer (
  customer_sk   NVARCHAR(64)  NOT NULL,
  customer_id   NVARCHAR(64)  NOT NULL,
  name          NVARCHAR(256),
  plan_id       NVARCHAR(64),
  valid_from    DATE          NOT NULL,
  valid_to      DATE
)
WITH (
  DISTRIBUTION = REPLICATE,
  CLUSTERED COLUMNSTORE INDEX
);

CREATE TABLE analytics.fct_usage (
  usage_id      NVARCHAR(64)  NOT NULL,
  customer_sk   NVARCHAR(64)  NOT NULL,
  plan_id       NVARCHAR(64)  NOT NULL,
  event_ts      DATETIME2     NOT NULL,
  api_calls     BIGINT        NOT NULL
)
WITH (
  DISTRIBUTION = HASH(customer_sk),
  CLUSTERED COLUMNSTORE INDEX,
  PARTITION (event_ts RANGE RIGHT FOR VALUES (
    '2026-01-01', '2026-02-01', '2026-03-01', '2026-04-01'
  ))
);