AI DuckDB schema generator

CREATE SCHEMA IF NOT EXISTS marts;

CREATE TABLE IF NOT EXISTS marts.dim_customer (
    customer_sk BIGINT NOT NULL,
    customer_id VARCHAR NOT NULL,
    plan_id VARCHAR,
    attributes JSON,
    effective_date TIMESTAMP NOT NULL,
    expiry_date TIMESTAMP NOT NULL,
    is_current BOOLEAN NOT NULL,
    PRIMARY KEY (customer_sk)
);

CREATE TABLE IF NOT EXISTS marts.fct_usage (
    usage_id VARCHAR NOT NULL,
    customer_sk BIGINT NOT NULL,
    event_ts TIMESTAMP NOT NULL,
    api_calls BIGINT NOT NULL,
    PRIMARY KEY (usage_id),
    FOREIGN KEY (customer_sk) REFERENCES
        marts.dim_customer(customer_sk)
);