CREATE TRANSIENT TABLE clip_initial_metrics (
    clip_id VARCHAR
    , user_id NUMBER(38,0)
    , user_uid VARCHAR
    , clip_created_at TIMESTAMP_NTZ
    , window_minutes NUMBER(38,0)
    , window_start_time TIMESTAMP_NTZ
    , window_end_time TIMESTAMP_NTZ
    , play_cnt NUMBER(38,0) DEFAULT 0
    , play_duration_seconds NUMBER(38,0) DEFAULT 0
    , n_like_events NUMBER(38,0) DEFAULT 0
    , n_undolike_events NUMBER(38,0) DEFAULT 0
    , net_like_events NUMBER(38,0) DEFAULT 0
    , n_dislike_events NUMBER(38,0) DEFAULT 0
    , n_undodislike_events NUMBER(38,0) DEFAULT 0
    , net_dislike_events NUMBER(38,0) DEFAULT 0
    , n_share_events NUMBER(38,0) DEFAULT 0
    , n_download_events NUMBER(38,0) DEFAULT 0
    , n_makepublic_events NUMBER(38,0) DEFAULT 0
    , n_makeprivate_events NUMBER(38,0) DEFAULT 0
    , net_public_toggle_events NUMBER(38,0) DEFAULT 0
    , net_positive_interactions NUMBER(38,0) DEFAULT 0
    , is_satisfactory_indirect VARIANT
    , is_satisfactory_direct VARIANT
    , is_satisfactory VARIANT
    , metadata VARIANT
    , p_date DATE
    , p_hour NUMBER(38,0)
) CLUSTER BY (p_date, p_hour)
COMMENT = 'Initial interaction and satisfaction metrics on user-owned clips';
