Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.9k views
in Technique[技术] by (71.8m points)

snowflake cloud data platform - Calling procedure through Snowsql

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.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

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".


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...