-- RDS_PLAYLIST table
-- Populated by Glue job rds_to_s3_bots_playlist_hourly_insert
CREATE TRANSIENT TABLE if not exists {playlist_table_name} CLUSTER BY (p_date, p_hour) (
    ID VARCHAR(255),
    CREATED_AT TIMESTAMP_TZ(9),
    UPDATED_AT TIMESTAMP_TZ(9),
    NAME VARCHAR(255),
    DESCRIPTION VARCHAR(16777216),
    USER_ID NUMBER(38,0),
    IS_PUBLIC BOOLEAN,
    IS_DISCOVER_PLAYLIST BOOLEAN,
    IS_TRASHED BOOLEAN,
    DISLIKE_COUNT NUMBER(38,0),
    FLAG_COUNT NUMBER(38,0),
    IS_PUBLIC_APPROVED BOOLEAN,
    PLAY_COUNT NUMBER(38,0),
    SKIP_COUNT NUMBER(38,0),
    UPVOTE_COUNT NUMBER(38,0),
    CREATED_SESSION_ID VARCHAR(255),
    P_DATE DATE,
    P_HOUR NUMBER(38,0)
);
