AI Amazon Redshift schema generator

CREATE TABLE analytics.dim_customer (
  customer_sk   VARCHAR(64)   NOT NULL ENCODE ZSTD,
  customer_id   VARCHAR(64)   NOT NULL ENCODE ZSTD,
  name          VARCHAR(256)            ENCODE ZSTD,
  plan_id       VARCHAR(64)             ENCODE ZSTD,
  valid_from    DATE          NOT NULL  ENCODE AZ64,
  valid_to      DATE                    ENCODE AZ64,
  PRIMARY KEY (customer_sk)
)
DISTSTYLE ALL
SORTKEY (customer_id, valid_from);

CREATE TABLE analytics.fct_usage (
  usage_id      VARCHAR(64)   NOT NULL ENCODE ZSTD,
  customer_sk   VARCHAR(64)   NOT NULL ENCODE ZSTD,
  plan_id       VARCHAR(64)   NOT NULL ENCODE ZSTD,
  event_ts      TIMESTAMP     NOT NULL ENCODE AZ64,
  api_calls     BIGINT        NOT NULL ENCODE AZ64,
  PRIMARY KEY (usage_id)
)
DISTSTYLE KEY DISTKEY (customer_sk)
COMPOUND SORTKEY (event_ts, customer_sk);