Configure a dbt Semantic Layer integration

Sigma supports dbt Semantic Layer integrations, allowing you to leverage your predefined dbt metrics in Sigma workbooks. This document explains how to configure a dbt Semantic Layer in Sigma. To query an existing integration, see Query a dbt Semantic Layer integration.

System and user requirements

• You must be assigned the Admin account type.
• You must have a dbt Cloud integration configured in Sigma. The dbt Semantic Layer is not available for dbt Core integrations. See Manage dbt integration.
• You must use the same dbt service account token that you use for the dbt integration, and that token must be configured with the following permissions: Semantic Layer Only, Metadata Only, and Read-Only. See the dbt documentation on Service account tokens.
• You need a dbt environment ID. See the dbt documentation on the dbt environment command.

Configure a dbt Semantic Layer integration

1. Go to Administration > Account.

2. In the Integrations section, select Edit next to your dbt integration.

3. In the dbt Integration section, fill out the required fields:

   Service Token	Your dbt service account token.
   Access URL	The URL of your existing Sigma dbt integration. This is likely cloud.getdbt.com (not semantic-layer.cloud.getdbt.com).
   Environment ID	Your dbt environment ID.

4. Select Save.