O'Reilly logo

Amazon Redshift: A Columnar Database SQL and Architecture by David Cook, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3 – System Tables

“He who asks a question may be a fool for five minutes, but he who never asks a question remains a fool forever.”

-Unknown

Amazon Redshift System Tables

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required