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.