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	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.

Language: English