There are several types of system tables and views here are there prefixes which categorize purpose:
- SVV_ prefixedviews contain information about database objects with references to transient STV tables.
- SYS_ prefixed views are used to monitor query and workload usage for provisioned clusters and serverless workgroups.
- STL_ prefixed views are generated from logs that have been persisted to disk to provide a history of the system.
- STV_ prefixed tables are virtual system tables that contain snapshots of the current system data. They are based on transient in-memory data and are not persisted to disk-based logs or regular tables.
- SVCS_ prefixed views provide details about queries on both the main and concurrency scaling clusters.
- SVL_ prefixed views provide details about queries on main clusters.