Create models using Looker Looks

If you've already invested in modeling business data in Looker, you may want to use your Looks as the basis for Hightouch models.

When you import a model from Looker, Hightouch converts your Look into a SQL query and runs it directly against your data warehouse. As you publish changes in Looker, your Hightouch model updates to reflect the latest version of your Look.

Supported sources

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

• Amazon Redshift
• Amazon Athena
• Google BigQuery
• Greenplum Database
• PostgreSQL
• Snowflake

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 4 credentials.
• Client secret - You can find this in your Looker API 4 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.

Tips and 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.