AI BigQuery schema generator

CREATE 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
)
PARTITION BY valid_from
CLUSTER BY customer_id, plan_id
OPTIONS (description = "SCD2 customer dimension");

CREATE TABLE analytics.fct_usage (
  usage_id      STRING       NOT NULL,
  customer_sk   STRING       NOT NULL,
  plan_id       STRING       NOT NULL,
  event_ts      TIMESTAMP    NOT NULL,
  api_calls     INT64        NOT NULL
)
PARTITION BY DATE(event_ts)
CLUSTER BY customer_sk, plan_id;