PROCEDURES view¶
This Information Schema view displays a row for each stored procedure defined in the specified (or current) database.
For more information about stored procedures, see Stored procedures overview.
Columns¶
| Column Name | Data Type | Description |
|---|---|---|
| PROCEDURE_CATALOG | VARCHAR | Database that the stored procedure belongs to. |
| PROCEDURE_SCHEMA | VARCHAR | Schema that the stored procedure belongs to. |
| PROCEDURE_NAME | VARCHAR | Name of the stored procedure. |
| PROCEDURE_OWNER | VARCHAR | Name of the role that owns the stored procedure. |
| ARGUMENT_SIGNATURE | VARCHAR | Type signature of the stored procedure’s arguments. |
| DATA_TYPE | VARCHAR | Return value data type. |
| CHARACTER_MAXIMUM_LENGTH | NUMBER | Maximum length of string return value, in characters. |
| CHARACTER_OCTET_LENGTH | NUMBER | Maximum length of string return value, in bytes. |
| NUMERIC_PRECISION | NUMBER | Numeric precision of numeric return value. |
| NUMERIC_PRECISION_RADIX | NUMBER | Radix of precision of numeric return value. |
| NUMERIC_SCALE | NUMBER | Scale of numeric return value. |
| PROCEDURE_LANGUAGE | VARCHAR | Programming language of the stored procedure. |
| PROCEDURE_DEFINITION | VARCHAR | Definition of the stored procedure. |
| CREATED | TIMESTAMP_LTZ | Creation time of the stored procedure. |
| LAST_ALTERED | TIMESTAMP_LTZ | Date and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes. |
| COMMENT | VARCHAR | Comment for this stored procedure. |
| EXTERNAL_ACCESS_INTEGRATIONS | VARCHAR | Names of external access integrations specified by the procedure’s EXTERNAL_ACCESS_INTEGRATION parameter. |
| SECRETS | JSON map | Map of secrets specified by the procedure’s SECRETS parameter, where map keys are secret variable names and map values are secret object names. |
| RUNTIME_VERSION | VARCHAR | Runtime version of the stored procedure’s handler language; NULL if the handler is written in SQL or JavaScript. |
| PACKAGES | VARCHAR | Names of packages specified in the PACKAGES clause of the CREATE PROCEDURE 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 stored procedure. 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. |
| ARTIFACT_REPOSITORY | VARCHAR | Name of the artifact repository used to resolve packages for the stored procedure. |
| OWNER_ROLE_TYPE | VARCHAR | The type of role that owns the object, for example ROLE. If a Snowflake Native App owns the object, the value is APPLICATION. Snowflake returns NULL if you delete the object because a deleted object does not have an owner role. |
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 may show less information compared to a SHOW command when both are executed by a user who holds the MANAGE GRANTS privilege.
-
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.