About This Block
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. While this block is not a perfect substitute for the AWS Console, it provides similar insights. This block is particularly useful for the class of user who needs to know if data is flowing normally and how tables are structured, in order to optimize queries and even the way they model data.
Ideal Data Types
It is highly recommended that a separate database connection to the Redshift cluster is used for this block, where the database user associated with the connection has access to the following tables/views:
stl_load_commits. These are tables that Looker generally does not need access to.
Included in the repo for this block are three files:
redshift_admin.model.lookml, which defines the base views/explores.
redshift_admin.view.lookml, which defines the various views, dimensions, and measures used to create the dashboard.
redshift_admin.dashboard.lookml, which defines the visualizations presented in the dashboard.
At present, this block results in five visualizations:
Table Load Summary
Recent Files Loaded
Recent Load Errors
Try it Yourself!
This block can be cloned directly from the Github repo (linked below). I also encourage people to contribute by forking the repo and making pull requests.
Update: The block now contains performance optimization views and dashboards as well!