-- Clip Comment table for storing clip comment data from RDS
-- This table is populated by the Glue job rds_to_s3_bots_clipcomment_hourly_upsert
CREATE TRANSIENT TABLE IF NOT EXISTS {clip_comment_table_name} CLUSTER BY (p_date, p_hour) (
    ID VARCHAR(255), CREATED_AT TIMESTAMP_TZ(9), UPDATED_AT TIMESTAMP_TZ(9),
    CONTENT STRING, TRACK_TIME_SECOND FLOAT, IS_DELETED BOOLEAN, DELETED_BY VARCHAR(255),
    NUM_LIKES NUMBER(38,0), CLIP_ID VARCHAR(255), PARENT_ID VARCHAR(255), USER_ID NUMBER(38,0),
    NUM_REPLIES NUMBER(38,0), RAW_MENTIONS VARIANT, P_DATE DATE, P_HOUR NUMBER(38,0)
);

