Snowflake get all details about Function in one query

Question

Hi Snowflake community.

I need to get details about Functions that are present in information_schema.functions (FUNCTION_SCHEMA, FUNCTION_CATALOG, FUNCTION_NAME, CREATED columns) and full definition like returned by SELECT GET_DDL('function', 'test_function()') in one query that is build programmatically.

I don't have function arguments at java code where i build query so i can't simply use GET_DDL with joins/unions/innerSelects/whatever. Also FUNCTION_DEFINITION column that is present in information_schema.functions is not enough.

Is there way to get definition of Function like provided by GET_DDL in other way? Much appreciate your help.

Answer 1

You want to use describe function. Here is usage from the documentation

describe function <name> ( [ <arg_data_type> ] [ , ... ] )

And if you wish to do something with the output of that function, you can use result_scan later on