For the complete documentation index, see llms.txt. This page is also available as Markdown.

dbt Core

  1. You can connect to Snowflake through a custom domain using the host parameter in profiles.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.

  2. 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.0

    Add to dbt_project.yml:

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

    Run dbt deps. Details →

Last updated