FUNCTIONS view | Snowflake Documentation (original) (raw)
This Information Schema view displays a row for each user-defined function (UDF), external function, or data metric function defined in the specified (or current) database.
For more information about external functions, see Writing external functions. For more information about UDFs, see User-defined functions overview.
Columns¶
| Column Name | Data Type | Description |
|---|---|---|
| FUNCTION_CATALOG | VARCHAR | Database to which the function belongs. |
| FUNCTION_SCHEMA | VARCHAR | Schema to which the function belongs. |
| FUNCTION_NAME | VARCHAR | Function name. |
| FUNCTION_OWNER | VARCHAR | Name of the role that owns the function. |
| ARGUMENT_SIGNATURE | VARCHAR | Type signature of the function’s arguments. |
| DATA_TYPE | VARCHAR | Data type of the function’s return value. |
| CHARACTER_MAXIMUM_LENGTH | NUMBER(9,0) | Maximum length in characters of a string return value. |
| CHARACTER_OCTET_LENGTH | NUMBER(9,0) | Maximum length in bytes of a string return value. |
| NUMERIC_PRECISION | NUMBER(9,0) | Numeric precision of numeric return value. |
| NUMERIC_PRECISION_RADIX | NUMBER(9,0) | Radix of precision of numeric return value. |
| NUMERIC_SCALE | NUMBER(9,0) | Scale of numeric return value. |
| FUNCTION_LANGUAGE | VARCHAR | Language of the function’s handler. |
| FUNCTION_DEFINITION | VARCHAR | Definition of the function’s handler. |
| VOLATILITY | VARCHAR | VOLATILE if the function is volatile; IMMUTABLE if it is immutable. |
| IS_NULL_CALL | VARCHAR(3) | YES if the function is called on null input; otherwise, NO. |
| IS_SECURE | VARCHAR(3) | YES if the function is secure; otherwise, NO. |
| CREATED | TIMESTAMP_LTZ(9) | Creation time of the function. |
| LAST_ALTERED | TIMESTAMP_LTZ(9) | Date and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes. |
| COMMENT | VARCHAR | Comment for the function. |
| IS_EXTERNAL [1] | VARCHAR(3) | YES if the function is an external function; otherwise, NO. |
| API_INTEGRATION [1] | VARCHAR | Name of the API integration object to authenticate the call to the proxy service an external function makes. |
| CONTEXT_HEADERS [1] | VARCHAR | Context header information for the external function. |
| MAX_BATCH_ROWS [1] | NUMBER(9,0) | Maximum number of rows in each batch sent to the proxy service for an external function. |
| REQUEST_TRANSLATOR [1] | VARCHAR | Name of the external function’s request translator (if any). |
| RESPONSE_TRANSLATOR [1] | VARCHAR | Name of the external function’s response translator (if any). |
| COMPRESSION [1] | VARCHAR | Type of compression used for serializing function payload. |
| IMPORTS | VARCHAR | Names of files (including their stage location and path) containing imported libraries. |
| HANDLER | VARCHAR | Name of the handler function or class. |
| TARGET_PATH | VARCHAR | Path to the stage in which Snowflake stores the compiled result of inline handler code. |
| RUNTIME_VERSION | VARCHAR | Runtime version of the function’s handler language; NULL if the function handler is written in SQL or JavaScript. |
| PACKAGES | VARCHAR | Names of packages specified in the PACKAGES clause of the CREATE FUNCTION statement. Currently, this column applies only when the handler is written in Python, Java, or Scala. |
| INSTALLED_PACKAGES | VARCHAR | Names of all packages installed by the function. This includes packages specified by the PACKAGES clause as well as their installed dependencies. Currently, this column applies only when the handler is written in Python. |
| IS_MEMOIZABLE | VARCHAR(3) | YES if the function is memoizable; otherwise, NO. |
| IS_DATA_METRIC | VARCHAR(3) | YES if the function is a data metric function; otherwise, NO. |
| IS_AGGREGATE | VARCHAR(3) | YES if the function is an aggregate function; otherwise, NO. |
Usage notes¶
- The view only displays objects for which the current role for the session has been granted access privileges. The view does not honor the MANAGE GRANTS privilege and consequently might show less information compared to a SHOW command when both are executed by a user who holds the MANAGE GRANTS privilege.
- Omitting a length for the VARCHAR type results in a VARCHAR that specifies the default maximum length. For more information, seeVARCHAR.
- The LAST_ALTERED column is updated when the following operations are performed on an object:
- DDL operations.
- DML operations (for tables only). This column is updated even when no rows are affected by the DML statement.
- Background maintenance operations on metadata performed by Snowflake.