Search documentation...

ChangelogBook a demoSign up

Create models using Sigma

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

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

This extension uses Sigma as a modeling method, not a data source. In other words, Sigma 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 Sigma.

Supported sources

You can create models based on Sigma workbooks for the following sources:

Connect to Sigma

In Hightouch, go to the Sigma configuration page in Extensions.

Enter the following fields:

  • Sigma cloud - Follow these instructions to find your Sigma cloud.
  • Client ID - Follow these instructions to find your client ID.
  • Client secret - Follow these instructions to create a secret tied to your client ID. Make sure to create an API token rather than Embed secret.

Build models

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

On the next screen, you can select which Sigma Workbook, Page, and Element to build your Hightouch model off of. Click View SQL to see the query that Hightouch executes on your data warehouse. Make sure to click Preview to preview your results before finishing your model setup.

Creating a Sigma-based model in the Hightouch app

Tips and troubleshooting

Worksbooks aren't visible in Hightouch

Hightouch only displays published Sigma workbooks, to which the credentials you entered into Hightouch have access.

If you don't see all the workbooks you expect in Hightouch, make sure:

  • The workbook is published (not in draft mode).
  • The user whose credentials you used to connect to Sigma has at least view access to the workbook; if they don't, share it with them and give them at least view access.

Sharing a workbook

Ready to get started?

Jump right in or a book a demo. Your first destination is always free.

Book a demoSign upBook a demo

Need help?

Our team is relentlessly focused on your success. Don't hesitate to reach out!

Feature requests?

We'd love to hear your suggestions for integrations and other features.

Last updated: Apr 21, 2023

On this page

Supported sourcesConnect to SigmaBuild modelsTips and troubleshootingWorksbooks aren't visible in Hightouch

Was this page helpful?