> For the complete documentation index, see [llms.txt](https://docs.espresso.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.espresso.ai/snowflake-optimizer/proxy-onboarding/proxy-onboarding-dbt-cloud.md).

# dbt Cloud

1. Open your dbt Cloud project and go to **Environments**.

   <div align="left"><img src="https://1611507959-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRex2SPQ8eJti1DS0eWrK%2Fuploads%2Fgit-blob-d8d2db290e899377bc84a36beb698fa134aa1ebb%2Fdbt-environments.png?alt=media" alt="dbt Cloud environments page"></div>
2. For each environment on the list, select the environment.

   <div align="left"><img src="https://1611507959-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRex2SPQ8eJti1DS0eWrK%2Fuploads%2Fgit-blob-469c9de24e90e062fcf9b592d2a59eb0f8efa9c4%2Fdbt-environment-list.png?alt=media" alt="dbt Cloud environment list"></div>
3. Click the settings icon.

   <div align="left"><img src="https://1611507959-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRex2SPQ8eJti1DS0eWrK%2Fuploads%2Fgit-blob-91aafb3dcc68f14f2b449372b540344761196178%2Fdbt-settings-icon.png?alt=media" alt="dbt Cloud settings icon"></div>
4. Click **Edit**.

   <div align="left"><img src="https://1611507959-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRex2SPQ8eJti1DS0eWrK%2Fuploads%2Fgit-blob-6e20dc086a2c789db3b5fab380677c70c4a487a8%2Fdbt-edit.png?alt=media" alt="dbt Cloud edit button"></div>
5. Set the Snowflake host in **Extended Attributes** (bottom of the page).

   <div align="left"><img src="https://1611507959-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRex2SPQ8eJti1DS0eWrK%2Fuploads%2Fgit-blob-895ba397b6992f16740df715c2e8a600f67dfd6e%2Fdbt-extended-attributes.png?alt=media" alt="dbt Cloud extended attributes"></div>
6. Click **Save**.

   <div align="left"><img src="https://1611507959-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRex2SPQ8eJti1DS0eWrK%2Fuploads%2Fgit-blob-ce09e25ef11d8bbe201e30f0530bcdb2e3e28cc4%2Fdbt-save.png?alt=media" alt="dbt Cloud save button"></div>
7. **Install dbt Markers.** dbt Markers is Espresso's small, open-source dbt package. It labels each query dbt runs with the model and run that sent it, so Espresso can make your dbt jobs cheaper while meeting your SLAs.

   Add to `packages.yml`:

   ```yaml
   packages:
     - git: "https://github.com/espressocomputing/dbt-markers.git"
       revision: v1.1.0
   ```

   Add to `dbt_project.yml`:

   ```yaml
   query-comment:
     comment: "{{ dbt_markers.query_comment(node) }}"
     append: true
   ```

   Run `dbt deps`. [Details →](https://docs.espresso.ai/snowflake-optimizer/proxy-onboarding/dbt-markers.md)
