-- create the procedure
CREATE OR REPLACE PROCEDURE user_agent_metadata_proc(p_date VARCHAR)
    RETURNS STRING
    LANGUAGE PYTHON
    RUNTIME_VERSION = '3.10'
    PACKAGES = ('snowflake-snowpark-python', 'user-agents')
    IMPORTS = ('@snowflake/branches/main/code/suno_prod/tables/other/user_agent_metadata/procedure.py')
    HANDLER = 'procedure.get_user_agent';