Stored Procedure: add parameter for month or hour
Hi I have the below Stored Procedure on Snowflake that sends out an email with all the load errors that exist in table SNOWFLAKE.ACCOUNT_USAGE.COPY_HISTORY for the last 24 hours. This is working ok but it the timeframe is currently fixed to “the last 24 hours”. Is there a way to add 2 x parameters to this procedure “hh” / “mm” followed by a number so it will scan accordingly to what is called for?