cube-js / cube-js/cube

Pre-Aggregations creates BigQuery table by default on US region

Open
#257 3 comments 2 reactions 0 assignees View on GitHub
driver:bigquery
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.