CREATE TRANSIENT TABLE AGG_USER_SUGGESTED_CREATORS_WEEKLY (
    user_id              NUMBER FOREIGN KEY REFERENCES suno_prod.prod.dim_user(user_id) COMMENT 'User who is being suggested creators',
    suggested_creators   ARRAY COMMENT 'Array of suggested creator IDs',
    suggestion_degrees   ARRAY COMMENT 'Array of connection types (1st_degree_connection, 2nd_degree_connection, reverse_connection, geo_based) matching suggested_creators order',
    p_date               DATE COMMENT 'Partition date (UTC)'
) CLUSTER BY (p_date)
COMMENT = 'Aggregated weekly suggested creators for each user with connection degree tracking.'; 