Connecting Amazon Redshift to Looker Studio

Before we dive into the tutorial, let's understand what Amazon Redshift and Looker Studio are, and why you might want to connect them.

Click here to access the tutorial showing the ways to share reports in Looker Studio.

Amazon Redshift is a cloud-based data warehousing service that allows you to store and analyze large volumes of data efficiently and at scale. It offers high performance and flexibility, making it a popular choice for businesses that need to handle complex data analytics.

Looker Studio , on the other hand, is a data analytics platform that enables users to explore, visualize, and share insights from data stored in various sources. It provides an intuitive and customizable interface for creating dashboards and interactive reports.

Advantages of Connecting Amazon Redshift to Looker Studio:

1. Access to Real-Time Data: The integration allows you to access data from Amazon Redshift in real-time, which is essential for making decisions based on up-to-date information.

2. Advanced Analytics: Looker Studio offers advanced analytics and visualization features that can help unlock valuable insights in your Amazon Redshift data.

3. Data Centralization: By connecting these two tools, you centralize your data, making it easier to access and collaborate across teams.

4. Customization: Looker Studio allows you to create custom dashboards and reports according to your specific needs, leveraging data from Amazon Redshift.

Centralizing Data in Redshift with Kondado

1. Registering Your Redshift as a Destination in Kondado: First, you need to login to Kondado and register your database as a destination to receive data from your tools. To register your Redshift as a destination, follow the step-by-step shown in our documentation.

2. Creating Your Data Sources: Data sources are the sources or tools from which you want to extract data to centralize in your data repository. To register your data sources in Kondado, visit our wiki and follow the respective step-by-step instructions.

3. Creating your first integration: Now that your data destination and data sources are registered, you can create your first integration by following the platform onboarding steps.

Note

To establish the connection between Redshift and Power BI, the IP used by Looker Studio, present in the section "show the list of IP addresses" at the link https://support.google.com/looker-studio/answer/11377200?hl=pt-BR#zippy=%2Cneste-artigo%2Cconectar-se-com-um-nome-do-host-ou-endere%C3%A7o-ip%2Cmostrar-a-lista-de-endere%C3%A7os-ip , whose image is shown in the figure below, must be allowed through your server's firewall. If your bank is hosted on AWS, here in this tutorial (from step 2 to 7) we show you how to release your IPs in the security group.

Connecting Amazon Redshift to Looker Studio

Go to Looker Studio and log in to your Looker Studio account and click on "Create".

Next, select the "Data Source" option.

Choose the Amazon Redshift connector.

Enter the connection configuration information. Then, click on "Authenticate".

Select the desired table from the list and then click on "Connect".

Done! Your Redshift database is now linked to Looker Studio, offering access to real-time data, production of advanced analyses, and the ability to customize reports to meet your needs.

Connect Amazon Redshift to Looker Studio

Centralize data in Amazon Redshift with Kondado and connect it to Looker Studio to build interactive dashboards.

Register Redshift as a destination in Kondado

Replicate sources into Redshift

Configure the sources you need (ads, CRM, e-commerce, ERPs) and set Kondado to load them into Redshift at the frequency you choose.

Allow Looker Studio IPs in your Redshift security group

On AWS, edit the security group attached to your Redshift cluster and add inbound rules for the Looker Studio IP ranges listed in Google's documentation.

Create the Redshift data source in Looker Studio

In Looker Studio, click Create > Data Source, choose Amazon Redshift, fill in connection details, and click Authenticate.

Pick a table and start building visuals

Select the Redshift table you want to use, click Connect, and start dragging fields into charts, scorecards, and tables in your report.

Share dashboards and review pipeline cadence

Share the report with your team. Adjust the Kondado pipeline schedule if you need fresher data — dashboards reflect whatever is currently in Redshift.

Frequently asked questions

What is Amazon Redshift and why use it with Looker Studio?▼

Amazon Redshift is a managed cloud data warehouse built for analytics on large datasets. Connecting it to Looker Studio lets your team explore the data with interactive dashboards, while Kondado centralizes sources into Redshift on the schedule you choose.

How do I centralize data in Redshift using Kondado before connecting to Looker Studio?▼

Three steps: register Redshift as a destination in Kondado, create the data sources you want to replicate, and configure pipelines into Redshift. See the Kondado overview for more details.

What firewall configuration is required to connect Redshift to Looker Studio?▼

Looker Studio's IP ranges must be allowed by your Redshift security group. Find the current IP list in Google's Looker Studio documentation and add an inbound rule on the Redshift port (default 5439).

What are the steps to connect Amazon Redshift to Looker Studio?▼

In Looker Studio, click Create > Data Source, select Amazon Redshift, fill in host, database, user, and password, click Authenticate, then choose the table you want to use in the report.

What benefits does Looker Studio offer when paired with Redshift?▼

You get a centralized data layer, customizable dashboards, easy sharing, and the ability to combine Redshift data with other Looker Studio sources. Pair it with Kondado pipelines to keep Redshift fed automatically.

How often will my Looker Studio dashboards update?▼

Looker Studio queries Redshift when the report is loaded or refreshed, so dashboards reflect the latest data Kondado has loaded into Redshift. Configure your Kondado pipelines at the frequency you choose.

Written by

Thassyo Pereira·Published 2023-11-08·Updated 2026-04-26