> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hightouch.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Create models using Sigma

> Connect Hightouch to your Sigma instance and build Hightouch models using existing workbooks.

If you've already invested in modeling business data in [Sigma](https://www.sigmacomputing.com/), you may want to use your Sigma workbooks as the basis for [Hightouch models](https://docs.hightouch.com/getting-started/concepts.md#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.

> [!NOTE]
>
> 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](https://docs.hightouch.com/syncs/create-your-first-sync.md#connect-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:

* [Amazon Redshift](https://docs.hightouch.com/sources/amazon-redshift.md)
* [Databricks](https://docs.hightouch.com/sources/databricks.md)
* [Greenplum Database](https://docs.hightouch.com/sources/greenplum.md)
* [Google BigQuery](https://docs.hightouch.com/sources/google-bigquery.md)
* [PostgreSQL](https://docs.hightouch.com/sources/postgresql.md)
* [Snowflake](https://docs.hightouch.com/sources/snowflake.md)

## Connect to Sigma

In Hightouch, go to the [**Sigma configuration page**](https://app.hightouch.com/extensions/sigma/configuration?from=docs) in **Extensions**.

Enter the following fields:

* **Sigma cloud** - Follow [these instructions](https://help.sigmacomputing.com/hc/en-us/articles/360037430573-Technical-Specifications#h_01EJF3BT46HVZ8YMNFQ149SD0A) to find your Sigma cloud.
* **Client ID** - Follow [these instructions](https://help.sigmacomputing.com/hc/en-us/articles/4408555307027-Get-an-API-Token-and-Client-ID) to find your client ID.
* **Client secret** - Follow [these instructions](https://help.sigmacomputing.com/hc/en-us/articles/4408555307027-Get-an-API-Token-and-Client-ID) 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](#supported-sources). 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](https://mintcdn.com/hightouch-3c037897/L_vQfA0JQEpeGUUo/images/models/create-model-sigma.png?fit=max\&auto=format\&n=L_vQfA0JQEpeGUUo\&q=85\&s=6732e48037222c385af4b117edbbb2b6)

## Tips and troubleshooting

### Worksbooks aren't visible in Hightouch

Hightouch only displays [published](https://help.sigmacomputing.com/hc/en-us/articles/1500010372322-Workbook-Lifecycle-Explore-Draft-and-Publish#h_01F6JP3G04NC4APKVE1DQ7ESH8) Sigma workbooks, to which the credentials [you entered into Hightouch](#connect-to-sigma) 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](#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](https://mintcdn.com/hightouch-3c037897/L_vQfA0JQEpeGUUo/images/models/share-sigma-workbook.png?fit=max\&auto=format\&n=L_vQfA0JQEpeGUUo\&q=85\&s=ebacc4160449f4bc385a37cb74c5f480)