Schema:
ACCOUNT_USAGE

STAGES View

This Account Usage view displays a row for each stage defined in the account.

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_ID NUMBER Internal/system-generated identifier for the stage.
STAGE_NAME TEXT Name of the stage.
STAGE_SCMEHA_ID NUMBER Internal/system-generated identifier for the schema of the stage.
STAGE_SCHEMA TEXT Schema that the stage belongs to.
STAGE_CATALOG_ID NUMBER Internal/system-generated identifier for the database of the stage.
STAGE_CATALOG TEXT Database that the stage belongs to.
STAGE_URL TEXT If the stage is external, location of the stage; NULL if it is internal.
STAGE_REGION TEXT If the stage is external, region where the stage resides; NULL if it is internal.
STAGE_TYPE TEXT Type of stage (User, Table, Internal Named, or External Named).
STAGE_OWNER TEXT Name of the role that owns the stage; NULL if it has been dropped.
COMMENT TEXT Comment for the stage.
CREATED TIMESTAMP_LTZ Date and time when the stage was created.
LAST_ALTERED TIMESTAMP_LTZ Date and time when the stage was last altered.
DELETED TIMESTAMP_LTZ Date and time when the stage was dropped.

Usage Notes

  • Latency for the view may be up to 120 minutes (2 hours).
  • The view only displays objects for which the current role for the session has been granted access privileges.
  • The view does not recognize the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command executed by a user who holds the MANAGE GRANTS privilege.