Calling procedure through Snowsql

Question

i am calling strored procedure thorugh SNOWSQL and getting below error.

002141 (42601): SQL compilation error: Unknown user-defined function ETL_SCHEMA.PROC

below is the snowsql query

snowsql -c newConnection  -o log_level=DEBUG -r ACCT_ROLE  -w ETL_XS_WH -d ETL_DEV_DB -s ETL_SCHEMA -q "CALL ETL_SCHEMA.PROC('202')" -o friendly=False  -o header=False -o output_format=plain -o timing=False

Please let me know if anything is wrong here.

Thanks.

Answer 1

Is CALL ETL_SCHEMA.PROC('202') working in your Snowflake Web GUI? Maybe its not a Stored Procedure but an User defined function.

Answer 2

The issue you are having is either permissions based or it's a search path issue.

I'd recommend prefixing the "etl_schema" with the database name (aka fully qualified name), and trying that. You can also simply run a select current_role(), current_database(), current_schema(); command instead of the call command to see what the context is, you might have something in the config that is overwriting the arguments passed in via the command.

I hope this helps...Rich

p.s. If this (or another) answer helps you, please take a moment to "accept" the answer that helped by clicking on the check mark beside the answer to toggle it from "greyed out" to "filled in".

Answer 3

I am also facing the issue while calling a procedure from Snowsql cli

I am using batch script as below, Can some one help me on the same

ECHO OFF ECHO started sql file loding in snowflake SNOWSQL call DEMO_DB.PUBLIC.proc_test(1.2, 1.4) PAUSE