directory keyboard_arrow_right source keyboard_arrow_right redshift-optimization-by-aws

Redshift Optimization by AWS

See the code

Database performance is key to getting the best experience out of Looker and any other analysis tool. With this Block in hand, users should have all the tools they need to fine tune their Redshift clusters.

Working with the experts at AWS, we augmented our existing Redshift Administration Block to include performance optimization views, explores and dashboards. We’ve also included a guide to help users identify and diagnose performance issues, as well as suggested actions to take based on those issues. We include several pieces of analysis:

  • Performance Overview Dashboard - offers users an aggregate view of performance across all clusters, tasks, and users
  • Query Inspector Dashboard - provides comprehensive information about a specific query, enabling users to understand the factors contributing to performance (e.g. bytes scanned, seconds to run, distribution, bytes broadcasted, etc.)

Based on the information provided by the query inspector, users should take corrective action to improve query performance. In this Block, we have a matrixed guide offering remedial actions for poorly performing queries.

See the code

Related Blocks

Hubspot Essentials by Keboola

Analysis of essential entities in Hubspot to understand the sales cycle and pipeline

Google Ad Manager

Google Ad Manager for Publishers is the world’s leading tool for ad revenue management.

Redshift Admin by AWS

This Block for Redshift Admin offers a substitute for AWS Console within Looker’s centralized interface.