Looker is a business intelligence software and big data analytics platform that helps customers explore, analyze and share real-time business analytics easily.
Additional reference: Supported Looker APIs
- A. Set up a Looker connection
- B. Edit Looker application details
- C. Edit advanced Looker settings
- D. Test the 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.
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.
- Log in to your Looker account.
- Navigate to Admin > Users.
- Add a new user or edit an existing user.
- Under the user, you will find API3 Keys. If none exists yet or you want to create new API credentials.
- Click Edit Keys, this will redirect to a page where you can view API3 Keys. (If none exists yet or you want to create new API credentials, click New API3 Key to generate a new pair.)
Before continuing, you have the opportunity to provide additional configuration information, if needed, for the Looker 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.