Snowflake · Schema
Procedure
A Snowflake procedure
Data LakesData SharingData WarehousingDatabaseSQL
Properties
| Name | Type | Description |
|---|---|---|
| name | string | Name of the procedure |
| execute_as | string | What permissions should the procedure execution be called with |
| 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) |