This Account Usage view displays a row for each sequence defined in the account.
|Column Name||Data Type||Description|
|SEQUENCE_ID||NUMBER||Internal/system-generated identifier for the sequence.|
|SEQUENCE_NAME||TEXT||Name of the sequence.|
|SEQUENCE_SCMEHA_ID||NUMBER||Internal/system-generated identifier for the schema of the sequence.|
|SEQUENCE_SCHEMA||TEXT||Schema that the sequence belongs to.|
|SEQUENCE_CATALOG_ID||NUMBER||Internal/system-generated identifier for the database of the sequence.|
|SEQUENCE_CATALOG||TEXT||Database that the sequence belongs to.|
|SEQUENCE_OWNER||TEXT||Name of the role that owns the sequence.|
|DATA_TYPE||TEXT||Data type of the sequence.|
|NUMERIC_PRECISION||NUMBER||Numeric precision of the data type of the sequence.|
|NUMERIC_PRECISION_RADIX||NUMBER||Radix of the numeric precision of the data type of the sequence.|
|NUMERIC_SCALE||NUMBER||Scale of the data type of the sequence.|
|START_VALUE||TEXT||Initial value of the sequence.|
|MINIMUM_VALUE||TEXT||Not applicable for Snowflake.|
|MAXIMUM_VALUE||TEXT||Not applicable for Snowflake.|
|NEXT_VALUE||TEXT||Next value that the sequence will produce.|
|INCREMENT||TEXT||Increment of the sequence generator.|
|CYCLE_OPTION||TEXT||Not applicable for Snowflake.|
|CREATED||TIMESTAMP_LTZ||Date and time when the sequence was created.|
|LAST_ALTERED||TIMESTAMP_LTZ||Date and time when the sequence was last altered.|
|DELETED||TIMESTAMP_LTZ||Date and time when the sequence was dropped.|
|COMMENT||TEXT||Comment for the sequence.|
- 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.