CREATE OR REPLACE TRANSIENT TABLE {public_clip_table_name} AS
SELECT 
    $1:id as clip_id,
    date(to_timestamp($1:created_at)) as p_date,
    hour(to_timestamp($1:created_at)) as p_hour
FROM {stage_path} (file_format => 'BASIC_PARQUET_LOADER', pattern => ('.*.parquet'))
