MSC-BQ0003

The Create Function Options clause is not supported by Snowflake

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium (waiting for CoE revision)

Description

This warning is added to the Create Function statement when the OPTIONS clause is included there.

Code Example

Input Code:

Input.sql

CREATE FUNCTION funcOptions (param1 integer)
RETURNS INTEGER
AS (x * y)
OPTIONS(
    description="UDF with all supported options",
    library=["gs://my-bucket/lib1.js", "gs://my-bucket/lib2.js"],
    endpoint="https://www.snowflake.com/foo",
    user_defined_context=[("key1","value1"),("key2", "value2")],
    max_batching_rows=1000
);

Output Code:

Output.sql

CREATE FUNCTION funcOptionsReturns (param1 integer)
RETURNS INTEGER
AS
    $$
 x * y
    $$
----** MSC-ERROR - MSC-BQ0003 - THE CREATE FUNCTION OPTIONS CLAUSE IS NOT SUPPORTED BY SNOWFLAKE **
--OPTIONS(
--    description="UDF with all supported options",
--    library=["gs://my-bucket/lib1.js", "gs://my-bucket/lib2.js"],
--    endpoint="https://www.snowflake.com/foo",
--    user_defined_context=[("key1","value1"),("key2", "value2")],
--    max_batching_rows=1000
--)
 ;

Recommendations

• No additional user actions are required, it is just informative.

• Add manual changes to the not transformed expression.

• If you need more support, you can email us at [email protected]