Why am I unable to provision GBQ connector?

Question

During the provisioning of the GBQ connector, we get the following error.

 "errorCode": 8010, 
"errorDetailMessage": "Validation failed for adapter bigquery and tenant IU4CG67ZlzTA6Xa 
error message: Location in tenant configuration is null, the location for 
dataset [GenericData{classInfo=[datasetId, projectId], {datasetId=USIX_MDM_DEV,
 projectId=avian-silicon-329723}}] is [us-west1]. Please ensure that all preconditions for
 the adapter are met", "foundErrors": null,

Answer

• Make sure that the customer has set the correct bigquery roles.

• Make sure that you have configured your GCP Credentials in the GBQ connector (per the documentation in https://docs.reltio.com/en/integrate/export-data-from-reltio-in-bulk/export-data-from-reltio-to-business-intelligence-tools/reltio-google-bigquery-gbq-connector/configure-the-reltio-gbq-connector/provision-your-reltio-tenant-for-the-gbq-connector/configure-your-gcp-credentials-in-the-gbq-connector---optional

PUT https://<envirnoment>-data-pipeline-hub.reltio.com/api/tenants/<tenantId>/adapters/bigquery/secrets

Request body

{
"secretsName": "<REDACTED>",
"secretsArn": "<REDACTED>"
}

Results body

{
"reltio.datapipelinehub.adapters.bigquery.gcp.privateKey": "*****",
"reltio.datapipelinehub.adapters.bigquery.gcp.clientEmail": "*****"
}

• Review the dataset with the customer

Example:

Based on the definition in the above screen, make sure that your GCP project name and GCP dataset name are set as the following

• GCP project name: avian-silicon-329723
• GCP dataset name: USIX_MDM_DEV

Make sure that you validate the connector using the following API call.

POST https://<environment>-data-pipeline-hub.reltio.com/api/tenants/<tenantId>/adapters/bigquery/validate