SHOW EXTERNAL FUNCTIONS¶
Lists all the external functions created for your account.
For more information, see Writing External Functions.
Syntax¶
SHOW EXTERNAL FUNCTIONS [ LIKE '<pattern>' ]
Parameters¶
LIKE 'pattern'
Filters the command output by object name. The
pattern
supports the SQL wildcard characters (%
and_
):An underscore (_) matches any single character.
A percent sign (%) matches any sequence of zero or more characters.
The filter uses case-insensitive pattern matching. For example, the following patterns return the same results:
... LIKE '%testing%' ...
... LIKE '%TESTING%' ...
Usage Notes¶
The command does not require a running warehouse to execute.
The command returns a maximum of 10K records for the specified object type, as dictated by the access privileges for the role used to execute the command; any records above the 10K limit are not returned, even with a filter applied.
To view results for which more than 10K records exist, query the corresponding view (if one exists) in the Snowflake Information Schema.
To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.
The commands SHOW FUNCTIONS and SHOW USER FUNCTIONS also display information about external functions.
Examples¶
Show all external functions:
SHOW EXTERNAL FUNCTIONS;
Show only external functions matching the specified regular expression:
SHOW EXTERNAL FUNCTIONS LIKE 'SQUARE%';