CREATE TRANSIENT TABLE IF NOT EXISTS suno_prod.prod.agg_play_info_hourly_v1 (
    USER_ID NUMBER(38,0)
    , USER_UID VARCHAR(255)
    , CLIP_ID VARCHAR(255)
    , IS_USER_SONG_OWNER BOOLEAN
    , PLATFORM VARCHAR(255)
    , PLAY_DURATION_THRESHOLD FLOAT
    , PLAY_DURATION_SEC FLOAT
    , PLAY_CNT NUMBER(38,0)
    , HIGH_INTENT_LISTENING VARIANT
    , P_DATE DATE
    , P_HOUR NUMBER(38,0)
) CLUSTER BY (P_DATE, P_HOUR);
