Search documentation...

K

If you've invested in defining Looks in Looker, you may want to use them as the basis for models in your downstream data needs.

In Hightouch, you can use Looker Looks as a source for models. When you create a Hightouch model based on a Look, Hightouch converts that Look to SQL and runs it against your configured source.

Supported sources

You can create models based on Looker Looks for the following sources:

Connect to Looker

In Hightouch, go to the Extensions page and select Looker.

Enter the following fields:

  • (Optional) Tunnel - If you've previously set up an SSH tunnel and want to use it to connect to Looker, you can select it here.
  • URL - Hightouch uses this URL to connect to your Looker instance. The format is often https://<instance_name>.looker.com. Refer to Looker's documentation if you have a non-standard Looker setup.
  • Client ID - You can find this in your Looker API 3 credentials.
  • Client secret - You can find this in your Looker API 3 credentials.

If you need to create credentials, refer to Looker's documentation on authentication with an SDK.

Select a Look

After configuring your Looker credentials, you can create a model using a source that supports Looker. Select your source and then choose Import Model from Looker as your modeling method.

On the next screen, you can select which Look you want to base your model on.

Troubleshooting

If you encounter any error messages during Look-based model setup, confirm the following about your credentials.

Permissions

You must be a Looker admin to retrieve your Looker connection URL. Check Looker's documentation on roles, permissions, and access for more information.

Looker URL

Check you're using the correct URL by consulting Looker's API connection troubleshooting guide.

    Need help?

    Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.

    • Connection issues with your data warehouse?
    • Confusing API responses from destination systems?
    • Unsupported destination objects or modes?
    • Help with complex SQL queries?

    Feature Requests?

    If you see something that's missing from our app, let us know and we'll work with you to build it!

    We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.

On this page

Supported sourcesConnect to LookerSelect a LookTroubleshootingPermissionsLooker URL

Was this page helpful?