Reltio Connect

 View Only

  • 1.  Reltio Data Sharing with Databricks - Unmerge events

    Posted 20 days ago

    How to fetch the Unmerge events from Reltio Catalog(Table Name)  



    ------------------------------
    Balavenkatesh Pandurangan
    Bread financial
    OH
    ------------------------------


  • 2.  RE: Reltio Data Sharing with Databricks - Unmerge events

    Reltio Employee
    Posted 8 days ago

    Hello Balavenkatesh,

    Could you please elaborate more on the exact information you are looking for?

    Thank you,

    Ankur



    ------------------------------
    Ankur Gupta
    ------------------------------

    Original Message


  • 3.  RE: Reltio Data Sharing with Databricks - Unmerge events

    Posted 6 days ago 
    

    We were using the following query to fetch the unmerge events, but the activities table was not getting populated. Eventually, we identified that the root cause was "activityLogEnabled": false on the DataShare connection.
    

    SELECT a.activityID, a.activityTimestamp, i.eventType, i.objectUri, i.data
    FROM <catalog>.<schema>.activities a
    LATERAL VIEW explode(a.items) AS i
    WHERE i.eventType = 'ENTITIES_SPLITTED' ORDER BY a.activityTimestamp DESC;


    ------------------------------
    Balavenkatesh Pandurangan
    Bread financial
    OH
    ------------------------------

    Original Message


  • 4.  RE: Reltio Data Sharing with Databricks - Unmerge events

    Posted 6 days ago
    we need to extract all the golden copy of the customer information for a given customer. How to extract it 


    ------------------------------
    Balavenkatesh Pandurangan
    Bread financial
    OH
    ------------------------------

    Original Message


  • 5.  RE: Reltio Data Sharing with Databricks - Unmerge events

    Reltio Partner
    Posted 5 days ago

    Based on your query, I understand you are looking to export golden records for a given customer, you can achieve it using below API

    POST {ExportServiceURL}/export/{{tenant}}/entities and use filter serachbyOv=True.

    Additionally if you want to filter based on entity IDs (for a specific customers) as a valueList item, you can use below API to upload the entity IDs in the text file and export only those using above API mentioned.



    ------------------------------
    Mohammed Ahmed
    Publicis Sapient
    NJ
    ------------------------------

    Original Message


  • 6.  RE: Reltio Data Sharing with Databricks - Unmerge events

    Reltio Employee
    Posted 5 days ago

    Hello Balavenkatesh,

    You would need to setup the data share with Databricks that has the "OV-only" scenario enabled. Once you have that data share active, in Databricks, you can make use of the table entity_customer to get the golden record for a particular customer. 



    ------------------------------
    Ankur Gupta
    ------------------------------

    Original Message


Related Content