How to integrate my Redshift Warehouse with Looker Studio?

Introduction

Looker studio is an intuitive and easy to use, self-serve business intelligence (BI) tool, that allows you to visualize your data in vibrant reports and dashboards, helping you draw actionable insights to guide your business decisions.

In order to link your Data Warehouse to Looker Studio, you will need to use Connectors. Click here to view a list of connectors.

Steps to Connect Redshift to Looker Studio

  1. Sign in to Looker Studio. You will reach the Home Page of Looker Studio.

    looker studio home page

  2. In the top left, click + Create then select Data Source.

    looker studio create data source

  3. A page will open up listing connectors supported by Looker Studio. Click on the required connector to connect to data. Typing in the required connector’s name in the search box will make it easy to find it. You can change the name of the Data Source by editing the name on the top left corner of the screen.

    looker studio redshift list

  4. Select the Redshift connector to access this data source.

  5. If prompted, click Authorize to allow Looker Studio to access your data on your behalf.

    looker studio redshift authorise

  6. Provide your account details and proceed to add the data source.

    looker studio redshift oauth

  7. Setup the connection to your database using either of these two methods:

Option 1 : Connect with a hostname or IP address:

  1. On the left, select BASIC.

  2. Enter the connection details:

    1. Hostname or IP address

    2. Port (Optional)

    3. Database

    4. Username

    5. Password

looker studio redshift basic authenticate

Option 2 : Connect with a JDBC URL:

  1. On the left, select JDBC URL.

  2. Enter the connection details:

    1. Username

    2. Password

    3. JDBC URL

Example: jdbc:redshift://<hostname or IP address>[:<port>]/<database>

looker studio redshift jdbc authenticate
NOTE

  1. Looker Studio can’t connect to localhost. You must use a public hostname or IP address.

  2. You can find your JDBC URL from the General Information of the cluster that you want to use on the AWS admin console.

jdbc url view

  1. To enable a secure connection, check Enable SSL, then provide your SSL configuration files. This step is optional.

  2. Once completed, click on AUTHENTICATE.

  3. Select your required table from the list. Then, click on Connect on the top right corner.

  4. This will open up a list of all the fields in the selected table.

  5. You are now ready to create a Report/ Visualisation using Looker Studio.

  6. You can read more about connecting Looker Studio to Amazon Redshift here.

Finding your DataChannel managed Redshift Warehouse details

  1. Login to the DataChannel Console.

  2. Access the Data Warehouse page by clicking on the Data Warehouse Tab on the sidebar.

    dc managed redshift 1

  3. Click on the card of the data warehouse that you want to connect to Looker Studio .

  4. The following screen would show up. All the required details will be available in the form that opens up.

dc managed redshift 2

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.