-- Contest table for storing contest data from RDS
CREATE TRANSIENT TABLE IF NOT EXISTS {contest_table_name} CLUSTER BY (p_date) (
    ID VARCHAR(255), CREATED_AT TIMESTAMP_TZ(9), UPDATED_AT TIMESTAMP_TZ(9), NAME STRING, TYPE VARCHAR(255),
    DESCRIPTION STRING, START_TIME TIMESTAMP_TZ(9), END_TIME TIMESTAMP_TZ(9), SUBMISSIONS_PLAYLIST_ID VARCHAR(255),
    CAN_DOWNLOAD_REMIXES BOOLEAN, IMAGE_S3_ID VARCHAR(255), P_DATE DATE
);

