Simba ODBC Driver fails with “dataset not found in location US” error

Problem

A query made through Simba ODBC Driver to BigQuery table located outside US region will fail with the following error:

Not found: Dataset {project_id}:{dataset_id} was not found in location US

Environment

  • BigQuery
  • Simba ODBC Driver

Solution

For every connection, follow the steps below:

  1. Create a temporary dataset for large results in the same region that the queried source table is located. If one does not exist already.
  2. Set LargeResultsDataSetID property, specifying the temporary dataset created.

Cause

When a temporary dataset for large results does not exist, the Simba ODBC Driver connector will create a dataset in the US region. Due to limitations from Google, the location for the new temp dataset cannot be specified.

Because the temp dataset is located in US region, the query will look for the source dataset within US region, leading to dataset not found error.