# Cross-Region Query Error in dbt Cloud with BigQuery

**URL:** <https://discourse.getdbt.com/t/cross-region-query-error-in-dbt-cloud-with-bigquery/19601>\
**Category:** In-Depth Discussions\
**Tags:** bigquery, dbt-cloud\
**Created:** [June 4, 2025, 8:16am UTC](https://discourse.getdbt.com/t/cross-region-query-error-in-dbt-cloud-with-bigquery/19601 "2025-06-04T08:16:47Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vigneshmailappan](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/vigneshmailappan/32/5743_2.png) [@vigneshmailappan](https://discourse.getdbt.com/u/vigneshmailappan)\
**Post date:** [June 4, 2025, 8:16am UTC](https://discourse.getdbt.com/t/cross-region-query-error-in-dbt-cloud-with-bigquery/19601/1 "2025-06-04T08:16:47Z")

</div>

How to change location dynamically ? or how to query cross region data ?

I’m using dbt Cloud with BigQuery as my data warehouse. My dbt Cloud environment is configured to run in the EU multi-region, but I’m trying to use a public dataset:

SELECT \* FROM `dbt-tutorial.stripe.payment`

This dataset is located in the US multi-region, and I’m getting the following error:

Not found: Dataset dbt-tutorial:stripe was not found in location EU

🔍 What I’ve Tried:  
Verified that my dbt Cloud environment is set to EU.  
Tried to define the source in sources.yml, but I understand that BigQuery location can’t be set there.  
I’d prefer not to switch my dbt Cloud environment to US, since my main data is in EU.