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