Configure a dbt Semantic Layer integration (Beta)

🚩

This documentation describes a public beta feature and is under construction. This documentation should not be considered part of our published documentation until this notice, and the corresponding Beta flag on the feature in Sigma, are removed. As with any beta feature, the feature discussed below is subject to quick, iterative changes. The latest experience in the Sigma service may differ from the contents of this document.

Beta features are subject to the disclaimer on Beta features.

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 integration configured in Sigma. See Manage dbt integration.
• You must have a dbt service account token 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.