Schema:

ACCOUNT_USAGE

PROCEDURES View¶

This Account Usage view displays a row for each stored procedure defined in the account.

For more information about stored procedures, see Stored Procedures Overview.

Columns¶

Column Name

Data Type

Description

PROCEDURE_CATALOG

TEXT

Database to which the stored procedure belongs.

PROCEDURE_SCHEMA

TEXT

Schema to which the stored procedure belongs.

PROCEDURE_NAME

TEXT

Name of the stored procedure.

PROCEDURE_OWNER

TEXT

Name of the role that owns the stored procedure.

ARGUMENT_SIGNATURE

TEXT

Type signature of the stored procedure’s arguments.

DATA_TYPE

TEXT

Return value data type.

CHARACTER_MAXIMUM_LENGTH

NUMBER

Maximum length in characters of string return value.

CHARACTER_OCTET_LENGTH

NUMBER

Maximum length in bytes of string return value.

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

TEXT

Language of the stored procedure.

PROCEDURE_DEFINITION

TEXT

Stored procedure definition.

CREATED

TIMESTAMP_LTZ

Creation time of the stored procedure.

LAST_ALTERED

TIMESTAMP_LTZ

Date and time the object was last altered. See Usage Notes.

COMMENT

TEXT

Comment for this stored procedure.

DELETED

TIMESTAMP_LTZ

Date and time when the procedure was dropped.

RUNTIME_VERSION

TEXT

Runtime version of the language used by the procedure.

PACKAGES

TEXT

Packages requested by the procedure.

PROCEDURE_SCHEMA_ID

NUMBER

Internal/system-generated identifier of the schema to which the stored procedure belongs.

PROCEDURE_CATALOG_ID

NUMBER

Internal/system-generated identifier of the database to which the stored procedure belongs.

OWNER_ROLE_TYPE

TEXT

The type of role that owns the object, either ROLE or DATABASE_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).

    • Background maintenance operations on metadata performed by Snowflake.