Snowflake · Schema
UserDefinedFunction
A snowflake UDF
Data LakesData SharingData WarehousingDatabaseSQL
Properties
| Name | Type | Description |
|---|---|---|
| name | string | The name of the UDF |
| is_temporary | boolean | Specifies whether the UDF is temporary or not |
| is_aggregate | boolean | Specifies whether the UDF is an aggregate function. Applicable only for Python language type |
| is_memoizable | boolean | Indicates whether the function is memoizable. Applicable only for Python language type. |
| is_table_function | boolean | True if the UDF is a table function; false otherwise. |
| valid_for_clustering | boolean | True if the UDF is valid for clustering; false otherwise. |
| is_secure | boolean | Specifies whether the function/procedure is secure or not |
| arguments | array | List of arguments for the function/procedure |
| comment | string | Specifies a comment for the function/procedure |
| body | string | Function/procedure definition |
| created_on | string | The date and time when the function/procedure was created |
| schema_name | string | The name of the schema in which the function/procedure exists. |
| database_name | string | The name of the database in which the function/procedure exists. |
| min_num_arguments | integer | The minimum number of arguments |
| max_num_arguments | integer | The maximum number of arguments |
| owner | string | Role that owns the function/procedure |
| owner_role_type | string | The type of role that owns the function/procedure |
| is_builtin | boolean | If the function/procedure is built-in or not (user-defined) |