dbt Core
You can connect to Snowflake through a custom domain using the
hostparameter inprofiles.yaml:my_project: target: dev outputs: dev: type: snowflake account: myorg-myaccount host: $account.espressocomputing.com user: <user> # ...Each project can be configured to use its own profile if needed.
See the dbt docs for more information.
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:packages: - git: "https://github.com/espressocomputing/dbt-markers.git" revision: v1.1.0Add to
dbt_project.yml:query-comment: comment: "{{ dbt_markers.query_comment(node) }}" append: trueRun
dbt deps. Details →
Last updated