-- create the procedure
CREATE OR REPLACE PROCEDURE agg_play_info_hourly_v0_proc(p_date VARCHAR, p_hour NUMBER)
    RETURNS STRING
    LANGUAGE PYTHON
    RUNTIME_VERSION = '3.10'
    PACKAGES = ('snowflake-snowpark-python')
    IMPORTS = ('@suno_etl/branches/main/snowflake/code/tables/aggregation/agg_play_info_hourly/v0/procedure.py')
    HANDLER = 'procedure.merge_datafromes';
