-- RDS_PREVIEW_CLIP table
-- Populated by Glue job rds_to_s3_bots_previewclip_hourly_upsert
CREATE TRANSIENT TABLE IF NOT EXISTS {preview_clip_table_name} CLUSTER BY (p_date, p_hour) (
    ID VARCHAR(255),
    CREATED_AT TIMESTAMP_TZ(9),
    UPDATED_AT TIMESTAMP_TZ(9),
    CLIP_ID VARCHAR(255),
    USER_ID NUMBER(38,0),
    PREVIEW_SECONDS NUMBER(38,0),
    P_DATE DATE,
    P_HOUR NUMBER(38,0)
);

