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