Configure the BigQuery region

Learn how to configure the BigQuery region on the Octopai Client so dataset discovery matches your Google Cloud dataset location.

BigQuery dataset discovery is region-dependent. You must configure a region that matches the location of your datasets in Google Cloud.

The connector supports the following region values:

Open the following file on the Octopai Client server:
C:\Program Files (x86)\Octopai\Service\Settings\bigQuerySettings.json
In Google Cloud Console, go to BigQuery > Dataset > Dataset properties and verify your dataset location.

important

The configured region must match the dataset location.

If the configured region does not match the dataset location, the connection test or metadata extraction may fail or return no datasets.
Locate the entry whose connectionId matches your BigQuery connection in bigQuerySettings.json.
Set the region property to US or EU based on the dataset location.
Use EU for the EU multi-region and European regional locations. Use US for the US multi-region and US regional locations.

The following example shows a bigQuerySettings.json entry with the region set to EU:
```
{
  "proxy": null,
  "extractIndirect": false,
  "connectionId": 102,
  "indirectProjectId": "",
  "region": "EU"
}
```
Restart the Cloudera Data Lineage Service before you run the extraction again.