Business Intelligence Software

Looker for AWS Redshift: Technical Overview

Provided by Looker

Category Business Intelligence Software

Type White Paper

Length 9

Publish Date February 01 2015

Date posted May 11 2015


AWS continues to set the standard for delivering infrastructure services in the cloud. Amazon Redshift extends that power with a high-performance petabyte-scale data warehousing solution for today's enormous analytic workloads.

In the post-cloud era, the traditional data warehousing model of moving “all data from everywhere” into an on-premises megaserver for advanced analytics breaks down. Data-savvy, born-of-the-web companies are looking for a more streamlined solution that can exploit the scale and economics of the cloud. This is what Looker and Amazon Redshift provide.

This technical paper examines the factors that impact the performance, scale, and cost of the Looker for Redshift solution. You'll learn:
•    Four methods for moving data into Redshift
•    How to tune your Redshift database to optimize Looker performance, including recommendations for schema design and architecture
•    How to tune your Looker model to optimize Redshift performance, including details on joins, filters, caching, and derived tables
•    Two methods for monitoring query performance and how your data models are being used

Recommended for You


Programming languages to avoid learning in 2018

Dan Swinhoe casts a critical eye on the future


A c-suite guide to blockchain 2018

Kathryn Cave looks at the big trends in global tech

Most Recent Comments

Our Case Studies

IDG Connect delivers full creative solutions to meet all your demand generatlon needs. These cover the full scope of options, from customized content and lead delivery through to fully integrated campaigns.


Our Marketing Research

Our in-house analyst and editorial team create a range of insights for the global marketing community. These look at IT buying preferences, the latest soclal media trends and other zeitgeist topics.



If it were legal, would your organization hack back?