-- RDS_USER_SHARE table
-- Populated by Glue job rds_to_s3_growth_usershare_hourly_upsert
CREATE TRANSIENT TABLE IF NOT EXISTS {user_share_table_name} CLUSTER BY (p_date, p_hour) (
    ID VARCHAR(16777216), -- Unique share identifier
    SOURCE VARCHAR(16777216), -- Source of the share
    PLATFORM VARCHAR(16777216), -- Platform where content was shared
    CONTENT_ID VARCHAR(16777216), -- ID of the shared content
    CONTENT_TYPE VARCHAR(16777216), -- Type of the content
    SHARER_ID NUMBER(38,0), -- User who shared the content
    CREATED_AT TIMESTAMP_TZ(9), -- When the share was created
    UPDATED_AT TIMESTAMP_TZ(9), -- When the share was last updated
    P_DATE DATE, -- Partition date
    P_HOUR NUMBER(38,0), -- Partition hour
    CONTENT_OWNER_ID NUMBER(38,0) -- Owner of the shared content
);

