dbt Semantic Layer
Steps and required credentials to connect dbt Semantic Layer to Squadbase
This connector allows Squadbase AI to query your dbt Semantic Layer — retrieving metrics and dimensions defined in your dbt project — for analysis and dashboard creation.
Required Information
| Field | Description |
|---|---|
| Semantic Layer Host URL | The host URL shown in your dbt Cloud Semantic Layer settings. |
| Environment ID | The numeric ID of the dbt Cloud environment where Semantic Layer is enabled. |
| Service Token | A service token issued in dbt Cloud Account settings with the Semantic Layer Only permission set. |
How to Obtain Each Value
Semantic Layer Host URL
- Log in to dbt Cloud
- Navigate to Account settings → Semantic Layer
- Copy the host URL shown in the configuration panel
The host varies by region:
| Region | Example host |
|---|---|
| US (multi-tenant) | semantic-layer.cloud.getdbt.com |
| EMEA | semantic-layer.emea.dbt.com |
| APAC | semantic-layer.au.dbt.com |
Single-tenant (e.g. pe571.us1.dbt.com) | pe571.semantic-layer.us1.dbt.com |
You can paste the full /api/graphql URL as-is — Squadbase will strip the path automatically.
Environment ID
- In dbt Cloud, navigate to Orchestration → Environments
- Click the environment where Semantic Layer is enabled
- The environment ID is the numeric value in the URL:
https://cloud.getdbt.com/accounts/{account_id}/environments/{environment_id}/...
Alternatively, the ID is shown directly on the Semantic Layer settings page.
Service Token
- In dbt Cloud, go to Account settings → Service tokens
- Click + New token
- Select the Semantic Layer Only permission set
- Copy the generated token and store it in a safe place
A personal access token can also be used in place of a service token.