redshift-console 0.1.2

Monitor and manage your Redshift cluster.

Redshift Console’s goal is to be the tool to monitor and manage a Redshift cluster. The first release has basic tools to monitor running queries, WLM queue and your tables/schemas.

After over a year of managing our Redshift cluster with a collection of scripts and queries, we decided to bundle this into a more user friendly tool that can be used by a wider audience. This project also aims to uncover all the useful information hidden in Redshift’s Developer Guide (such as the table design status query).

Features

• Inflight queries view with option to cancel any query and view related alerts (when available; from STL_ALERT_EVENT_LOG).

• WLM queue view.

• Schemas view with additional information for each table including: total size (rows/MB), unsorted area size, is the table properly distributed and more.

• Load errors (aggregated view) from the past 24h, based on STL_LOAD_ERRORS

Authors

Arik Fraimovich and Oren Itamar.