dbt

dbt Core

To route dbt Core BigQuery workloads through Yuki, configure your dbt execution environment to use the Yuki Proxy as the BigQuery endpoint.

You can do this by setting the following environment variable either in advance or inline as part of the dbt command:

BIGQUERY_EMULATOR_HOST=https://<your-yuki-proxy> dbt run ...

Once set, dbt will automatically send BigQuery queries through Yuki during execution, allowing Yuki to apply routing and optimization logic - with no changes required to your dbt models, profiles, or credentials.

---

dbt Cloud

To integrate dbt Cloud with Yuki, you’ll need to configure the BigQuery API endpoint at the environment level. This setup is required for each dbt Cloud environment where you want queries to be routed through the Yuki Proxy.

Step 1 - Open the dbt Cloud environment

Navigate to the relevant dbt Cloud environment:

https://cloud.getdbt.com/deploy/<ACCOUNT_ID>/projects/<PROJECT_ID>/environments

Select the environment you want to configure.

Step 2 - Update environment settings

In the environment settings page, scroll to the Extended attributes section:

https://cloud.getdbt.com/deploy/<ACCOUNT_ID>/projects/<PROJECT_ID>/environments/<ENV_ID>/settings

Add the following key-value pair:

api_endpoint: https://<your-yuki-proxy>

The exact Yuki Proxy URL for your organization will be provided by the Yuki team.

Save the changes once the attribute is added.

Step 3 - Repeat per environment

Repeat this configuration for every dbt Cloud environment where you want Yuki optimization to apply (for example: staging, production).

Once configured, dbt Cloud will route BigQuery queries through Yuki automatically, allowing Yuki to apply optimization and routing logic to your dbt workloads - with no changes required to your models, credentials, or project configuration.