-- create the procedure
CREATE OR REPLACE PROCEDURE fact_play_hourly_insert_data_validation_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/fact/fact_play/data_validation_procedure.py', '@suno_etl/branches/main/snowflake/code/utils/validation/data_validation.py')
    HANDLER = 'data_validation_procedure.main';

