SHOW EXTERNAL FUNCTIONS¶

Lists all the external functions created for your account.

For more information, see Writing external functions.

See also:

SHOW FUNCTIONS , SHOW USER FUNCTIONS, CREATE EXTERNAL FUNCTION , ALTER FUNCTION

Syntax¶

SHOW EXTERNAL FUNCTIONS [ LIKE '<pattern>' ]
           [ IN { APPLICATION <application_name> | APPLICATION PACKAGE <application_package_name> }  ]
Copy

Parameters¶

LIKE 'pattern'

Optionally filters the command output by object name. The filter uses case-insensitive pattern matching, with support for SQL wildcard characters (% and _).

For example, the following patterns return the same results:

... LIKE '%testing%' ...
... LIKE '%TESTING%' ...

. Default: No value (no filtering is applied to the output).

[ IN ... ]

Optionally specifies the scope of the command. Specify one of the following:

APPLICATION application_name, . APPLICATION PACKAGE application_package_name

Returns records for the named Snowflake Native App or application package.

Usage notes¶

  • Columns that start with the prefix is_ return either Y (yes) or N (no).

  • 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.

Examples¶

Show all external functions:

SHOW EXTERNAL FUNCTIONS;
Copy

Show only external functions matching the specified regular expression:

SHOW EXTERNAL FUNCTIONS LIKE 'SQUARE%';
Copy