Schema:

ACCOUNT_USAGE

STAGES view¶

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

Stages are named objects that can be used for loading/unloading data. For more information, see CREATE STAGE.

Columns¶

Column Name

Data Type

Description

STAGE_ID

NUMBER

Internal/system-generated identifier for the stage.

STAGE_NAME

TEXT

Name of the stage.

STAGE_SCHEMA_ID

NUMBER

Internal/system-generated identifier for the schema of the stage.

STAGE_SCHEMA

TEXT

Schema that the stage belongs to.

STAGE_CATALOG_ID

NUMBER

Internal/system-generated identifier for the database of the stage.

STAGE_CATALOG

TEXT

Database that the stage belongs to.

STAGE_URL

TEXT

If the stage is external, location of the stage; NULL if it is internal.

STAGE_REGION

TEXT

If the stage is external, region where the stage resides; NULL if it is internal.

STAGE_TYPE

TEXT

Type of stage (Internal Named, or External Named).

STAGE_OWNER

TEXT

Name of the role that owns the stage; NULL if it has been dropped.

COMMENT

TEXT

Comment for the stage.

CREATED

TIMESTAMP_LTZ

Date and time when the stage was created.

LAST_ALTERED

TIMESTAMP_LTZ

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

DELETED

TIMESTAMP_LTZ

Date and time when the stage was dropped.

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.

INSTANCE_ID

NUMBER

Internal/system-generated identifier for the instance which the object belongs to.

Usage notes¶

  • Latency for the view may be up to 120 minutes (2 hours).

  • The view only displays objects for which the current role for the session has been granted access privileges.

  • The view does not recognize the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command 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.