create TRANSIENT TABLE SUNO_PROD.PROD.TRENDING_NOW (
    CLIP_ID VARCHAR(255),
    VERIFIED_LIKES NUMBER,
    NORMALIZED_LISTEN_DURATION FLOAT,
    SCORE FLOAT,
    INFERRED_LANGUAGE VARCHAR(255),
    P_DATE DATE,
    P_HOUR NUMBER(38,0)
)COMMENT='table contains the trending clips in the past 24 hours'
;