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.