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?

Question

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?

Frederico DionÃ­sio · Accepted Answer

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

Frederico DionÃ­sio · Answer

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

Frederico DionÃ­sio · Answer

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

Frederico DionÃ­sio · Answer

SHOW FUNCTIONS Commands

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 124 - DEA-C01 discussion

Suggested answer: D

0 comments