CREATE TRANSIENT TABLE SUNO_PROD.PROD.OWNED_CLIP_ANALYSIS (
    -- Primary identifiers
    backup_clip_id STRING COMMENT 'Backup clip ID'
    , ownership_status STRING COMMENT 'Always owned for this table'
    , ownership_reason STRING COMMENT 'Always subscribed for this table'
    , clip_id STRING COMMENT 'Primary clip ID'
    , user_id STRING COMMENT 'User ID'
    
    -- User subscription info
    , user_usage_plan STRING COMMENT 'User usage plan from clips user_tier'
    
    -- Timestamps
    , clip_created_at TIMESTAMP_TZ COMMENT 'Timestamp when clip was created'
    , created_at TIMESTAMP_TZ COMMENT 'Record creation timestamp'
    , updated_at TIMESTAMP_TZ COMMENT 'Record last updated timestamp'
    
    -- Partition field
    , p_date DATE COMMENT 'Partition date'
    
) CLUSTER BY (p_date)
COMMENT = 'Analysis table for owned clip analysis based on user subscription status. Tracks clips that users own based on their subscription tier.';