Set up a connection to Looker

Looker is a business intelligence software and big data analytics platform that helps customers explore, analyze and share real-time business analytics easily.

Looker documentation: API guide, Authentication

Additional reference: Supported Looker APIs

Contents

• A. Set up a Looker connection
• B. Edit Looker application details
  • Retrieve your Looker client ID and secret
• C. Edit advanced Looker settings
• D. Test the connection

A. Set up a Looker connection

Start establishing a connection to Looker in either of the following ways:

• From the Resources menu, select Connections. Then, click + Create connection at the top right.
      – or –
• While working in a new or existing integration, you can add an application to a flow simply by clicking Add source or Add destination/lookup.

In the resulting Application list, select Looker.

The Create connection pane opens with required and advanced settings.

B. Edit Looker application details

At this point, you’re presented with a series of options for providing Looker authentication.

Name(required): Provide a clear and distinguishable name. Throughout integrator.io imports and exports, you will have the option to choose this new connection, and a unique identifier will prove helpful later when selecting among a list of connections that you’ve created.

Application (required, non-editable): A reminder of the app you’re editing.

Instance URL: Enter your Looker instance URL. For example, ‘https://test-instance.cloud.looker.com' is an instance. If your URL includes a port number, it should be specified as a part of the Instance URI. For example, https://test-instance.cloud.looker.com:443

Client ID (required): Enter the client ID as found in your Looker developer dashboard.

Client secret (required): Enter the client secret in your Looker developer dashboard. Multiple layers of protection are in place, including AES 256 encryption, to keep your connection’s client secret safe. When editing this form later, you must enter this value again; it is stored only when the connection is saved and never displayed as text.

Generate token (required): Click the Generate token button to have integrator.io fill in an encrypted access token or enter the token generated for you by Looker. Multiple layers of protection are in place, including AES 256 encryption, to keep your connection’s token safe. When editing this form later, you must enter this value again; it is stored only for a saved connection.

C. Edit advanced Looker settings

Before continuing, you have the opportunity to provide additional configuration information, if needed, for the Looker connection.

D. Test the connection

Once you have configured the Looker connection, you have a few options for continuing:

• Save – click this button to test the connection, commit the new connection so that it will be available to all integrations for your account
• Save & close – click to test and save the connection and exit the Create connection pane
• Cancel – click to exit without saving any new changes
• Test connection – click this button to verify that your new connection is free of errors

When you test or save the connection, it is verified before continuing.

The new connection is now successfully added to your account. It will be applied to the current source or destination app if you created it within a flow. Otherwise, you may proceed to register the connection with an integration.