Skip to main content
Martin FiserKeboola TEAM
Head of Professional Services @ Keboola
Asked a question 2 years ago

Stored procedures and UDFs in Snowflake (https://docs.snowflake.com/en/sql-reference/udf-overview.html) do not work (or work only in sandbox) - I would like use stored procedure, but there is a mistake during running. Is it possible create and call procedures in KBC transformation like in Snowflake?

Where am I?

In Keboola you can ask and answer questions and share your experience with others!

This is because the standard $ $  body delimiter is not supported on TR execution (link: https://docs.snowflake.net/manuals/sql-reference/sql/create-function.html#usage-notes265) and hence  (single quote) needs to be used instead.

Related Questions