AI Databricks schema generator

CREATE TABLE main.analytics.dim_customer (
  customer_sk   STRING       NOT NULL,
  customer_id   STRING       NOT NULL,
  name          STRING,
  plan_id       STRING,
  valid_from    DATE         NOT NULL,
  valid_to      DATE
)
USING DELTA
CLUSTER BY (customer_id, valid_from)
COMMENT 'SCD2 customer dimension';

CREATE TABLE main.analytics.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
CLUSTER BY (event_date, customer_sk);