CREATE TRANSIENT TABLE HOOK_BACKEND_EVENTS cluster by (p_date, p_hour, hook_id) (
    HOOK_ID VARCHAR(255),
    USER_ID VARCHAR(255),
    HOOK_EVENT_NAME VARCHAR(255),
    RECOMMENDATION_ID VARCHAR(255),
    HOOK_STATUS VARCHAR(255),
    PAYLOAD_STATUS VARCHAR(255),
    VIDEO_S3_ID VARCHAR(255),
    IS_TEST BOOLEAN,
    STAFF_REVIEW_STATUS VARCHAR(255),
    TIMESTAMP TIMESTAMP_TZ(9),
    SOURCE VARCHAR(255),
    P_DATE DATE,
    P_HOUR NUMBER(38,0)
) COMMENT='table for backend hook events'
;