CREATE TRANSIENT TABLE IF NOT EXISTS {{ user_top_score_songs_table_name }} (
    -- Core Identifiers
    USER_ID BIGINT COMMENT 'ID of the user who created the clip',
    CLIP_ID VARCHAR(255) COMMENT 'ID of the clip/song',
    -- Timestamps
    CREATED_AT TIMESTAMP_TZ COMMENT 'Timestamp of the creation of the clip',
    -- Engagement Metrics
    PLAY_CNT INT COMMENT 'Total play count over 5 days',
    PLAY_DURATION FLOAT COMMENT 'Total play duration over 5 days',
    LIKE_COUNT INT COMMENT 'Number of likes for the clip',
    
    -- Content Metadata
    LANGUAGE VARCHAR(255) COMMENT 'Language of the clip',
    STYLE_TAGS TEXT COMMENT 'Style tags associated with the clip',
    
    -- Calculated Fields
    SCORE FLOAT COMMENT 'Combined score based on play count, duration, and likes',
    ROW_CNT INT COMMENT 'Ranking within user (1 = highest scoring clip for user)',
    
    -- Partitioning columns
    P_DATE DATE NOT NULL COMMENT 'Partition date for the scoring run'
) 
CLUSTER BY (P_DATE, USER_ID); 
