I am trying to create a SQL stored procedure in Snowflake (Snowsight), but it is throwing run-time error. Not able to identify what the issue is.

Need to implement incremental load from S3 to Snowflake only using snowflake objects.
Accessing S3 location thru WINSCP :

Need to create a table with above 200M records using multiple underlying tables and couple views and lot of joins etc.
It is based on one main underlying fact table that has a date stamp (updates weekly). Others are mainly Dim tables.
We only need to keep x weeks of rolling data and update it weekly.

I am trying to run a data reconciliation stored procedure on each user that exists in the source table. To do this, I retrieve all distinct user IDs in that table and then run the procedure for each unique user. All of my tables and columns are in lower case so I need to use double quotes when passing the variable of table names.

I am trying to call a stored procedure in Snowflake and getting the following error message

I have a stored procedure that is pretty long but the next one i think reflects what it does:

I’m trying to create a snowflake procedure in SQL which takes two inputs (first is table_name and second is object where key is column_name and value is 1,2,3 etc.,). When the value is 1, then it should check if there are more than 10% null values in that column and return message based on successful and failed validations.

below is the stored procedure that we created and it returns table with columns ID, Name
how to Use the result set in snowflake select statement. I tried like below but it did not work