Bob, a Lead Data Engineer is looking out to get the function definition & queried below statement to check if this function is secure enough to use in his script or not.select is_secure from information_schema.functions where function_name = 'JOHNFUNCTION';From the query output he is sure that, Function is secure UDF, what are the way provided by snowflake to get the function definition of secure UDF?

Declaring a UDF as "secure" hide the definition from Bob & all the required Definition commands will throw error.

He can get the secure UDF definition using GET_DDL utility function.

UDF definition or text, is visible to users via Query Profile (in the web interface).

Declaring a UDF as "secure" hide the definition from Bob & all the required Definition commands will throw error.

A SQL UDF evaluates an arbitrary SQL expression and returns the result(s) of the expression. Which value type it can returns?

Scaler or Tabular depend on input SQL expression

The body of a UDF cannot contain DDL statements or any DML statement other than SELECT.

Scalar functions (UDFs) have a limit of 500 input arguments.

When using a query expression in a SQL UDF, do not include a semicolon within the UDF body to terminate the query expression.

You can include only one query expression.

Which UDF programming language is not supported with Snowflake Secure Data Sharing feature?

Become a Premium Member for full access