Looker

Marketplace

Develop for Marketplace

Blocks

Amazon Redshift Administration

By Google
Fine-tune your Redshift deployment with a comprehensive view of performance and query analysis.
Fine-tune your Redshift deployment with a comprehensive view of performance and query analysis.

Version

v3.0.1

Release Notes

Category

Blocks

SQL Dialects

Amazon Redshift

Overview

Install this block for free by importing the project(s) from the GitHub repository linked at the top of the listing.

This is not an officially supported Google product.

Short of giving everyone access to the AWS Console, it's difficult for non-AWS administrators to get insight into ETL cycles, recent load failures, table architectures, etc. This Block is meant to address this issue, at least in part. This Block gives insight into the following:

  • Table Load Summary
  • Recent Files Loaded
  • Recent Load Errors
  • Database Consumption
  • Table Architecture ​ This Block has been updated to include performance metrics as well.

From the README, these are the permissions required:

Connection and Permissions

  • Prerequisite: Ensure Looker is able to use its temp schema, according to our Standard Redshift connection instructions
  • Grant the SELECT privilege on:
  • STV_WLM_SERVICE_CLASS_CONFIG
  • SVV_TABLE_INFO
  • STV_TBL_PERM
  • STV_BLOCKLIST
  • STL_LOAD_COMMITS
  • By default, grants to the above tables will only allow the Redshift user to view their own activity.
    Since Looker normally connects as a single Redshift user, this usually means all Looker activity, which is normally fine.
    If you want the reports to include data from other users you can execute these grants with SYSLOG ACCESS

Related Content

BigQuery Information Schema Performance Monitoring

GoogleMonitor and Explore your BigQuery Usage and PerformanceBlocks

© 2025 Looker Data Sciences, Inc.
Privacy | Terms | Cookies