create or replace table RDS_OLD_CLIP_LYRICS (
    clip_id varchar(255) comment 'Clip ID',
    prompt text comment 'final lyrics before date is 2025-09-01',
    prompt_text text comment 'lyrics at clip genereation',
    created_at timestamp comment 'Timestamp of the creation of the clip lyrics',
    p_date date comment 'Partition date',
    p_hour int comment 'Partition hour'
) cluster by (p_date, p_hour) comment = 'Clip lyrics table for storing clip lyrics data from RDS (clip created before 2025-09-01, new clips are in dynamoDB)';
