Configure the Reltio GBQ Connector
Learn how to configure your GCP to receive data from your Reltio tenant.
Learn about the configuration steps needed to set up your GBQ connector.
| Step # | Activity | Notes |
|---|---|---|
| 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:
|
| 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:
|
| Provision your Reltio tenant for the GBQ Connector | ||
| 6. |
Configure a new GBQ pipeline in the Console with your:
| Enter 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:
| 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.
| 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:
| 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. |
| 12. |
Synchronize data between Reltio and the GBQ Connector:
|
If the synchronize task is successfully scheduled, you see a 200 OK status in the response. If your connection is unsuccessful, contact Reltio support. |