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.
This extension uses Looker as a modeling method, not a data source. In other words, Looker provides the SQL query, not the query results. Before enabling this extension, you must first create a source in Hightouch that connects to the same data warehouse used by Looker.
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.
Tips and troubleshooting
If you encounter any error messages during Look-based model setup, confirm the following about your credentials.
You must be a Looker admin to retrieve your Looker connection URL. Check Looker's documentation on roles, permissions, and access for more information.
Check you're using the correct URL by consulting Looker's API connection troubleshooting guide.