create TRANSIENT TABLE SUNO_PROD.PROD.TRENDING_MONTHLY (
    CLIP_ID VARCHAR(255),
    VERIFIED_LIKES NUMBER,
    NORMALIZED_LISTEN_DURATION FLOAT,
    SCORE FLOAT,
    INFERRED_LANGUAGE VARCHAR(255),
    P_DATE DATE
)COMMENT='table contains the trending clips in the past 30 days'
;