CREATE TRANSIENT TABLE IF NOT EXISTS {ddb_clip_meta_heavy_table_name} CLUSTER BY (p_date, p_hour, id) (
    -- Clip metadata fields
    id VARCHAR(255) COMMENT 'Primary key ID of the clip',
    prompt TEXT COMMENT 'Full prompt text for the clip',
    prompt_text TEXT COMMENT 'Processed prompt text',
    
    -- Partitioning columns
    p_date DATE COMMENT 'Partition date for table optimization',
    p_hour NUMBER(38, 0) COMMENT 'Partition hour for table optimization'
) COMMENT='DynamoDB table containing clip metadata with heavy text fields';

