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: User, Table, 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

Last altered time of the stage

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.