英文:
Execute Snowflake Procedure in Matilion
问题
我正在尝试在Matilion中使用Sql脚本组件执行Snowflake存储过程。
但是我收到了未知用户定义函数的错误。
有人可以帮助我调用Matilion作业中的存储过程吗？
谢谢！
英文:
I'm trying to execute Snowflake Stored Procedure in Matilion Using Sql Script component.
But i'm getting error as Unknown user defined function.
Can someone help me to call the procedure using Matilion Job.
Thank You !
答案1
得分: 0
这看起来像是一个名称解析错误。Snowflake不识别存储过程的名称。当尝试调用一个实际不存在的存储过程时，您将看到相同的通用错误消息...
您很可能需要：
- 用数据库和模式限定存储过程的名称
- 如果它们区分大小写，将名称放在双引号内。
在Matillion存储过程文章中有一个示例 CALL "${environment_database}"."${examples_schema}"."audit"('START', ${run_history_id}, NULL)
英文:
That looks like a name resolution error. Snowflake does not recognize the name of the stored procedure. You will see the same generic error message when trying to call a procedure that really does not exist...
You most likely need to
- qualify the procedure name with a database and a schema
- put the names inside double-quotes if they are case sensitive.
In the Matillion stored procedure article there is an example CALL "${environment_database}"."${examples_schema}"."audit"('START', ${run_history_id}, NULL)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论