Original Message:
Sent: 4/26/2024 9:50:00 AM
From: Vishvesh Reddy
Subject: RE: Potential Matches export to S3 bucket
Hi Gino,
Please guide us on how we can get the potential matches which includes the entity, matched entity and match rule(if possible) using snowflake. Is there a design document handy.
Thanks,
Vish
------------------------------
Vishvesh Reddy
Onetrust
------------------------------
Original Message:
Sent: 04-26-2024 09:43
From: Gino Fortunato
Subject: Potential Matches export to S3 bucket
The alternate way to do this would be to use the Snowflake/BigQuery/Databricks data pipeline. But unless you have one of those I think your best bet is to use the ROCS utility.
------------------------------
Gino Fortunato
Senior Solution Engineer
Reltio
Original Message:
Sent: 04-26-2024 09:35
From: Vishvesh Reddy
Subject: Potential Matches export to S3 bucket
Hi Gino,
We are trying to build a BI dashboard to get the potential duplicates so that our BDR can view this information and do data corrections.
This is a requirement from business to have a visibility of Potential duplicates
Thanks,
Vish
------------------------------
Vishvesh Reddy
Onetrust
Original Message:
Sent: 04-23-2024 11:11
From: Gino Fortunato
Subject: Potential Matches export to S3 bucket
BTW, what do you want to do with the extract once you have it in S3?
------------------------------
Gino Fortunato
Senior Solution Engineer
Reltio
Original Message:
Sent: 04-23-2024 11:11
From: Gino Fortunato
Subject: Potential Matches export to S3 bucket
Hi Vishvesh,
The ROCS utility here does not seem to directly support S3 destinations. https://bitbucket.org/reltio-ondemand/pot-mat-data-extract/src/master/. However, you can copy to S3 once you have the file.
------------------------------
Gino Fortunato
Senior Solution Engineer
Reltio
Original Message:
Sent: 04-22-2024 14:06
From: Vishvesh Reddy
Subject: Potential Matches export to S3 bucket
Hi There,
We would like to get a detailed report of all the potential matches existing in our tenant which provides both source entity and the matched entity and here are couple of questions we do have,
1. Is there an API call to do so. When asked in RIA, it did update with following information,
To export data for all potential matches in the tenant, you can use the /export/potential-matches
endpoint. This endpoint provides functionality which allows you to export merge tree data for all entities in a tenant. This is an asynchronous request which returns IDs of tasks which will perform exporting data. Using these IDs, you have an ability to track statuses of these tasks.
Here are the steps on how to use the /export/potential-matches
endpoint:
- Make a POST request to the
/export/potential-matches
endpoint. - In the request body, specify the following parameters:
tenantId
: The ID of the tenant from which you want to export data.format
: The format of the exported data. Supported formats are CSV, JSON, and XML.filter
: A filter expression that specifies which entities to export. For more information on filter expressions, see the Reltio documentation.
The link is broken and unable to view further information.
2. Can we use the ROCS utility for Potential Matches export to push a file to S3 bucket. We would like to automate this like a daily job.
Please provide your inputs.
Thanks,
Vish
------------------------------
Vishvesh Reddy
Onetrust
------------------------------