How can I check that whether my GBQ entity tables are synchronized with my tenant entity data in Reltio?

Question

How can I check whether my GBQ entity tables are synchronized with my tenant entity data in Reltio?

Answer

To verify synchronization between your Reltio tenant and Google BigQuery (GBQ) entity tables, follow these steps:

1. Retrieve Entity Count from Reltio

   Execute the following API call to obtain the total number of entities for a specific entity type:

   GET https://<environment>.reltio.com/reltio/api/<tenantId>/entities/_total?filter=equals(type,'configuration/entityTypes/<entityType>')
   

   This will return the total count of entities of the specified type in your Reltio tenant.

2. Retrieve Entity Count from GBQ

   Run the following SQL query in your GBQ environment to count the distinct entities:

   SELECT COUNT(DISTINCT Id)
   FROM `customer-facing.views_riq_dw_<environment>_<tenantId>.entity_<entityType>_source_*`
   WHERE deleted = FALSE
   

   This query counts the distinct entity IDs that are not marked as deleted in GBQ.

3. Compare Counts

   Compare the entity count from Reltio with the count from GBQ. If the numbers match, your data is synchronized. Minor discrepancies can occur due to processing delays or high system activity. Significant differences may indicate synchronization issues.

4. Additional Verification

   For a more detailed verification:

   • Run a Sync Job: Trigger a synchronization job using the following API:

     POST https://<environment>.reltio.com/reltio/api/<tenantId>/syncToDataPipeline
     

     This initiates the synchronization process between Reltio and GBQ.

   • Check Task Status: Monitor the status of the synchronization task:(docs.reltio.com)

     GET https://<environment>.reltio.com/reltio/api/<tenantId>/tasks/<taskId>
     

     Replace <taskId> with the ID of the synchronization task to check its progress and completion status.

   • Verify Queue Status: Ensure that the event queue is empty, indicating that all events have been processed:

     GET https://<hub-url>/status/tenant/<tenantId>/details
     

     A queue count of zero confirms that synchronization is complete.

References

• How can I check that whether my GBQ entity tables are synchronized with my tenant entity data in Reltio?(support.reltio.com)
• Synchronize data between Reltio and the GBQ Connector(docs.reltio.com)
• How to re-synchronize RI and GBQ with MDM?(support.reltio.com)
• Validate event transfer in GBQ with the Reltio UI(docs.reltio.com)