-- Contest Clip table for storing contest clip data from RDS
CREATE TRANSIENT TABLE IF NOT EXISTS {contest_clip_table_name} CLUSTER BY (p_date, p_hour) (
    ID VARCHAR(255), CREATED_AT TIMESTAMP_TZ(9), UPDATED_AT TIMESTAMP_TZ(9), DURATION FLOAT, IS_BASE_CLIP BOOLEAN,
    CLIP_ID VARCHAR(255), CONTEST_ID VARCHAR(255), USER_ID NUMBER(38,0), P_DATE DATE, P_HOUR NUMBER(38,0)
);

