-- Create DynamoDB item_info table for storing DynamoDB exports
CREATE TRANSIENT TABLE IF NOT EXISTS {ddb_item_info_table_name} CLUSTER BY (p_date, p_hour, type) (
    id VARCHAR(255) COMMENT 'Item ID from DynamoDB',
    type VARCHAR(255) COMMENT 'Type of item from DynamoDB',
    cover_photo_url TEXT COMMENT 'Cover photo URL',
    instagram_link TEXT COMMENT 'Instagram profile link',
    location TEXT COMMENT 'Location information',
    section_order TEXT COMMENT 'Section order data',
    soundcloud_link TEXT COMMENT 'SoundCloud profile link',
    spotify_link TEXT COMMENT 'Spotify profile link',
    user_inputted_genres TEXT COMMENT 'User-inputted genre information',
    x_link TEXT COMMENT 'X (Twitter) profile link',
    youtube_link TEXT COMMENT 'YouTube channel link',
    p_date DATE COMMENT 'Partition date for table optimization',
    p_hour NUMBER(38, 0) COMMENT 'Partition hour for table optimization',
    json_data VARIANT COMMENT 'Full JSON data from DynamoDB NewImage'
) COMMENT='DynamoDB item_info table from S3 exports';
