AI Snowflake schema generator

CREATE OR REPLACE TABLE 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,
  CONSTRAINT pk_dim_customer PRIMARY KEY (customer_sk)
)
CLUSTER BY (customer_id, valid_from);

CREATE OR REPLACE TABLE analytics.fct_usage (
  usage_id      STRING        NOT NULL,
  customer_sk   STRING        NOT NULL,
  plan_id       STRING        NOT NULL,
  event_ts      TIMESTAMP_NTZ NOT NULL,
  api_calls     NUMBER(18,0)  NOT NULL,
  CONSTRAINT pk_fct_usage PRIMARY KEY (usage_id)
)
CLUSTER BY (event_ts, customer_sk);