Snowflake Exam DEA-C01 Topic 1 Question 12 Discussion

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 snow-flake to get the function definition of secure UDF?