Solved: Simba ODBC driver error "Dataset xx was not found ... - Page 2

jonnyPS · 11-04-2022 04:36 AM

Hi,

I am using the Simba Google BigQuery ODBC 64-bit Linux driver (version 2.5 downloaded from https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers) and am able to successfully connect to my project and can view the list of tables in my dataset. However, when I try to query a table I get error:

"Dataset is not found. Not found: Dataset <dataset name> was not found in location US".

My dataset has a location of 'EU' when viewed in the Cloud console. I have configured my odbc.ini configuration file with parameters including Catalog and DefaultDataset but I still get the error.

Catalog=<project ID>
DefaultDataset=<dataset name>

I've also tried setting DefaultDataset as <project ID>.<dataset name>

Is there any way to define the location as 'EU' in my configuration, assuming that is what I need to do?

Thanks.

cristianrm

To solve this issue, please follow this steps:

(If not exist already) Create a temporary dataset for large results in the same region where the table is located.
Set the LargeResultsDataSetID specifying the temporary dataset created in step 1.

This limitation is caused 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 this limitation, the location for the new temp dataset cannot be specified.

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

View solution in original post

Simba ODBC driver error "Dataset xx was not found in location US"