Pre-Aggregations creates BigQuery table by default on US region
- Dominant language
- Rust
- Stars
- 20.8k
- Forks
- 2.1k
- Avg merge
- 1d 2h
- Merged PRs (30d)
- 181
Description
**Describe the bug**
I have a BigQuery dataset that is EU based, when creating a Pre-Aggregation, the table is created in the US region, therefore, when trying to run the Pre-Aggregation query, the main dataset can't be found.
**To Reproduce**
Steps to reproduce the behavior:
1. Have an EU dataset
2. Create a simple Pre-Aggregation
3. Build with the Pre-Aggregation as a measure
4. See error `Dataset was not found in location US`
**Expected behavior**
When creating a Pre-Aggregation, the Pre-Aggregation table must be created in the same region as the provided dataset.
**Version:**
0.11.16
**Additional context**
I've delete the table that was created in the US and created it with the same name in the EU and the queries worked.
Contributor guide
Assessment
This issue has not been assessed yet.