Accelerate the Value of Data

Configure the Reltio GBQ Connector

Learn how to configure your GCP to receive data from your Reltio tenant.

Before you can use the Google BigQuery (GBQ) connector, login to Zendesk and search for the Reltio Knowledge Base (KB) article Reltio Service Account for Reltio GBQ Connector or follow the link.

In the article, Reltio lists the the appropriate Google Cloud Platform (GCP) service account, based on whether your tenant uses Health Insurance Portability and Accountability Act (HIPAA) data or not. Record this service account as you need it to create a GCP project in your GBQ account. With this information, you are allowing Reltio to connect to your GBQ account and write events to the BigQuery dataset. For more information or for any issues accessing these Reltio service accounts, contact support.
Note: If you prefer to use your own service account instead of the Reltio-owned service account, follow the steps mentioned in Configure your GCP Credentials in the GBQ connector.

User journey at a glance

Learn about the configuration steps needed to set up your GBQ connector.

This table provides more information on these configuration steps, which are described in detail in the following sections.
Step #ActivityNotes
Create a GBQ Project/Dataset
1.Create a GCP project in your GBQ account.The project is used to provide permissions to the custom project and dataset roles.
2.Create a BigQuery dataset in the GCP project.The dataset allows the GBQ connector to deliver events from your Reltio tenant to the dataset.
3.Create a custom IAM role at the project level.You must add the following permissions:



4.Create a custom IAM role at the dataset level.You must add the following permissions:
  • bigquery.tables.create

  • bigquery.tables.delete

  • bigquery.tables.get

  • bigquery.tables.getData

  • bigquery.tables.list

  • bigquery.tables.update

  • bigquery.tables.updateData

5.Grant the roles permissions to Reltio’s or your GCP service account .You can either use Reltio's GCP service account and retain the content or use your service account. For whichever service account you choose, you must assign the following role at the project level for the service account:
  • Service Usage Consumer

To use your service account, apply the same permissions in steps 3 and 4 to your service account, configure your GCP credentials for your service account, and mention your service account name in step 6.
Provision your Reltio tenant for the GBQ Connector

Submit a provisioning request to Reltio Support - SUPERSEDED with your:

  • Tenant ID
  • Tenant environment

  • Tenant URL (if available)

  • GCP project name

  • GCP dataset name

  • Configuration choice

Provide the configuration options based on how you want your Reltio data tables or views to be displayed in GBQ.
7 (Optional)

Configure your GCP Credentials in the GBQ connector:

PUT {dphUrl}/api/tenants/{tenantId}/adapters/bigquery/secrets

You can add your email and private key in the request body to add your credentials to the tenant configuration.
Validate and Sync Reltio Data to GBQ
8.Validate access between Reltio's and your GCP service accounts.

POST https://{{dphUrl}}/api/tenants/{{ternantId}}/adapters/bigquery/validate

If Reltio's service account has access to your service account, you see a 200 OK status in the response, and the response body is empty.
9.Validate event transfer in GBQ with the Reltio UI.You can verify if event transfer is successful by changing an entity attribute in the Reltio UI.
10.Validate event transfer in GBQ with the Reltio API:

POST {{apiHost}}/reltio/reindex?tenantId={{tenant}}

You can use the reindex API to verify event transfer.
11. Recreate GBQ tables and views in your BigQuery dataset.This must be done to restore the tables and views after the connector is configured, since the data schema changes once the configuration is completed.

Synchronize data between Reltio and the GBQ Connector:

POST https://{{environment}}{{tenantId}}/syncToDataPipeline

If the synchronize task is successfully scheduled, you see a 200 OK status in the response.

If your connection is unsuccessful, contact Reltio support.