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 integration configured in Sigma. 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 TokenYour dbt service account token.
    Access URLThe URL of your existing Sigma dbt integration. This is likely cloud.getdbt.com (not semantic-layer.cloud.getdbt.com).
    Environment IDYour dbt environment ID.
  4. Select Save.