AI Microsoft Fabric schema generator

-- Fabric Warehouse (T-SQL)
CREATE TABLE analytics.dim_customer (
  customer_sk   VARCHAR(64)  NOT NULL,
  customer_id   VARCHAR(64)  NOT NULL,
  name          VARCHAR(256),
  plan_id       VARCHAR(64),
  valid_from    DATE         NOT NULL,
  valid_to      DATE
);

-- Fabric Lakehouse (Spark SQL on Delta in OneLake)
CREATE TABLE workspace.lakehouse.fct_usage (
  usage_id      STRING       NOT NULL,
  customer_sk   STRING       NOT NULL,
  plan_id       STRING       NOT NULL,
  event_ts      TIMESTAMP    NOT NULL,
  event_date    DATE         GENERATED ALWAYS AS (CAST(event_ts AS DATE)),
  api_calls     BIGINT       NOT NULL
)
USING DELTA
PARTITIONED BY (event_date);