STAGES view

This Information Schema view displays a row for each stage defined in the specified (or current) database.

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_CATALOG

TEXT

Database that the stage belongs to.

STAGE_SCHEMA

TEXT

Schema that the stage belongs to.

STAGE_NAME

TEXT

Name of the stage.

STAGE_URL

TEXT

Location of an external stage.

STAGE_REGION

TEXT

Region where the stage resides.

STAGE_TYPE

TEXT

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

STAGE_OWNER

TEXT

Name of the role that owns the stage.

COMMENT

TEXT

Comment for this stage.

CREATED

TIMESTAMP_LTZ

Creation time of the stage.

LAST_ALTERED

TIMESTAMP_LTZ

Date and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes.

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.