Snowflake stored procedure called from ADF

I am trying to call Snowflake stored procedure from ADF (lookup activity)that inserts the log count of all tables once it gets extracted from source/loads into snowflake. Stored procedure throws error...