Redshift Observatory

System Table Tracker

Introduction

I archive a subset of the system tables for every version of Redshift, and generate a page for every object (table, view, function, etc) in the Redshift.

This is the second version of the tracker; the original was ditzy and just generated pages. This version archives the system tables, and so I can produce whatever I want, whenever I want.

Note there's no manual annotation here - information is and is only that available from the system tables - but that's pretty useful, as it provides easy access to system table DDL and view SQL.

Note as of 2024-04-27, trailing track versions are being published. Trailing track unexpectedly turns out to have different version numbers from current track (I had though trailing track was always a current track release, but from some time ago - in fact at the time of writing, trailing track has a higher version number than current track). I've not yet introduced indications in the dumps here as to which versions are trailing and which are current.

System Table Versions

Permanent link to latest version is now here.

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Replacement System Tables System Table Tracker The Known Universe Twitter White Papers