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

# dbt Cloud

> Integrating dbt Cloud with Coalesce Quality

<Note>
  This guide will walk you through how to create a service token and set up the relevant configurations for your dbt Cloud project

  We need this information so we can connect to dbt and extract metadata such as runs and test failures. We only request read access to your metadata and won’t be able to read raw data or update or run any models.

  In order to be able to finish this guide you’ll need:
  <br /> → Access to dbt cloud
  <br /> → Having been assigned the owner role in dbt cloud

  ⏱️ Estimated time to finish: 10 minutes.
</Note>

## Name your integration

For example `dbt cloud`

## Set the API endpoint

The dbt Cloud default region is in the US but if you’re on the enterprise plan you can host your project in a different region. Select the region where your dbt Cloud project is hosted

* **Production (US):** [https://cloud.getdbt.com](https://cloud.getdbt.com) (*default*)
* **Production (Europe):** [https://emea.dbt.com](https://emea.dbt.com)
* **Production (AU):** [https://au.dbt.com](https://au.dbt.com)

## Generate a token

<Note>These steps will take you through how to create a token you can use to manage Coalesce Quality access to your dbt Cloud project</Note>

1. Open dbt cloud and go to **Account Settings** in the menu bar

<Frame>
  <img src="https://mintcdn.com/synq-15/FoG6-YKTU-ydVrtS/images/dbt/dbt-cloud-1.png?fit=max&auto=format&n=FoG6-YKTU-ydVrtS&q=85&s=5d50673cbdba079a9db4b6a0957d4656" width="2738" height="1156" data-path="images/dbt/dbt-cloud-1.png" />
</Frame>

* *If you don’t see this option in the sidebar you don’t have the right dbt permission. If this is the case, either ask your dbt admin to make you an **Owner** (expand to see how) or ask the dbt admin to complete the steps in this guide*
  <Frame>
    <img src="https://mintcdn.com/synq-15/FoG6-YKTU-ydVrtS/images/dbt/dbt-cloud-2.png?fit=max&auto=format&n=FoG6-YKTU-ydVrtS&q=85&s=c453c754ce5191d5e00dbb78f1b00d0c" width="2156" height="882" data-path="images/dbt/dbt-cloud-2.png" />
  </Frame>

2. Click **Service Tokens**

<Frame>
  <img src="https://mintcdn.com/synq-15/FoG6-YKTU-ydVrtS/images/dbt/dbt-cloud-3.png?fit=max&auto=format&n=FoG6-YKTU-ydVrtS&q=85&s=d7283bfe22491e048815d0e9e9e891ea" width="1794" height="1138" data-path="images/dbt/dbt-cloud-3.png" />
</Frame>

3. Create **New Token**

<Frame>
  <img src="https://mintcdn.com/synq-15/FoG6-YKTU-ydVrtS/images/dbt/dbt-cloud-4.png?fit=max&auto=format&n=FoG6-YKTU-ydVrtS&q=85&s=d216a868896a373d8c1e412a2cecc531" width="2708" height="734" data-path="images/dbt/dbt-cloud-4.png" />
</Frame>

4. **Name** your token

*This could be synq\_token so you can identify it later*

<Frame>
  <img src="https://mintcdn.com/synq-15/FoG6-YKTU-ydVrtS/images/dbt/dbt-cloud-5.png?fit=max&auto=format&n=FoG6-YKTU-ydVrtS&q=85&s=10ee171c23ce5eb703abedd532ae0e22" width="1426" height="1504" data-path="images/dbt/dbt-cloud-5.png" />
</Frame>

5. Click **Add** to add a new permission
6. Set permissions

* `Permission Set` should be set to **Read-Only.** This will let Coalesce Quality read your dbt logs
* `Project` should be set to your main dbt project. If you want to integrate multiple projects, add all projects you want to integrate or set to All Projects

<Frame>
  <img src="https://mintcdn.com/synq-15/FoG6-YKTU-ydVrtS/images/dbt/dbt-cloud-6.png?fit=max&auto=format&n=FoG6-YKTU-ydVrtS&q=85&s=31471e5982397648f591cbf522e87d47" width="1504" height="1504" data-path="images/dbt/dbt-cloud-6.png" />
</Frame>

7. **Save** the token
8. **Copy** the token value

<Warning>Make sure to write the token id down as you will not be able to access it again afterwards</Warning>

<Frame>
  <img src="https://mintcdn.com/synq-15/FoG6-YKTU-ydVrtS/images/dbt/dbt-cloud-7.png?fit=max&auto=format&n=FoG6-YKTU-ydVrtS&q=85&s=27621f8840c98257fb398767c162599b" width="1918" height="1156" data-path="images/dbt/dbt-cloud-7.png" />
</Frame>

## Select your dbt project

Choose your main dbt project

## Select the job(s) you want Coalesce Quality to monitor

You’ll most likely want to monitor your production and freshness job(s). Unless you have a good reason, we suggest you don’t monitor jobs such as CI, staging, or experimental jobs

# FAQ

### What access do you require?

We only request read access to your metadata and won’t be able to read raw data or update or run any models

### Will you store personal or business-critical data

Coalesce Quality only stores log level data and doesn’t access any actual data from your data warehouse

### Which artifacts are you collecting from dbt

We are collecting the following artifacts from dbt. For more information about dbt artifacts see [this article](https://docs.getdbt.com/docs/dbt-cloud/using-dbt-cloud/artifacts)

* manifest.json — to understand the structure of the warehouse
* run\_results.json — to see the status of executions
* catalog.json — to be able to provide catalog-like functionality
* Optionally sources.json — to capture dbt source freshness