“He who asks a question may be a fool for five minutes, but he who never asks a question remains a fool forever.”
Amazon Redshift provides access to the following types of system tables:
• STL tables for logging - These system tables are generated from Amazon Redshift log files to provide a history of the system. Logging tables have an STL prefix.
• STV tables for snapshot data - These tables are virtual system tables that contain snapshots of the current system data. Snapshot tables have an STV prefix.
• System views - System views contain a subset of data found in several of the STL and STV system tables. Systems views have an SVV or SVL prefix.
• System catalog tables - The ...