CREATE TRANSIENT TABLE ml_recs_web_song_feed_engagement (
    user_id VARCHAR(255) COMMENT 'Discordinfo user_id',
    user_uid VARCHAR(255) COMMENT 'Discordinfo uid',
    action_name VARCHAR(255) COMMENT 'Type of user action (e.g., SongFeedItemSeen, SongFeedItemLikeClicked, SongFeedItemPlayed)',
    section_id VARCHAR(255) COMMENT 'Feed section identifier (featured_feed_following, featured_feed_for_you, etc.)',
    section_title VARCHAR(255) COMMENT 'Title of the feed section',
    clip_id VARCHAR(255) COMMENT 'Clip id',
    comment_cnt NUMBER(38,0) COMMENT 'Number of comments on the song at time of interaction',
    like_cnt NUMBER(38,0) COMMENT 'Number of likes on the song at time of interaction',
    play_cnt NUMBER(38,0) COMMENT 'Number of plays on the song at time of interaction',
    last_action_timestamp TIMESTAMP_TZ(9) COMMENT 'Timestamp of the most recent action by this user on this clip',
    action_cnt NUMBER(38,0) COMMENT 'Total count of actions by this user on this clip in this p_date',
    p_date DATE COMMENT 'Partition date'
) 
COMMENT = 'Machine learning recommendations table tracking user engagement with song feed items across different feed sections';