Reltio Connect

 View Only
  • 1.  For the Snowflake Connector, How do you bring in relationships?

    Founding Member
    Posted 10-25-2021 09:55
    Would it create a table for each Relationship as the attributes could be significantly different based on relationship type? 
    #snowflake


    ------------------------------
    Sandro Palleschi
    Manager - Enterprise Data Services at Empire Life
    Empire Life
    ------------------------------


  • 2.  RE: For the Snowflake Connector, How do you bring in relationships?

    Reltio Employee
    Posted 10-25-2021 09:58
    The relationship will be handled in the same way as entity each and every entity type we have separate table, the same thing applies to the relationship type as well. Every relationship type will have a separate table and we will manage it in a separate table.

    Make sure you check out the #communitywebinar I hosted on #snowflake
    ​​

    ------------------------------
    Ganeshkumar Palanisamy
    ------------------------------



  • 3.  RE: For the Snowflake Connector, How do you bring in relationships?

    Founding Member
    Posted 10-25-2021 09:59
    Also what about matching metadata though? For instance, which matching rule caused this entity to be merged?

    ------------------------------
    Sandro Palleschi
    Manager - Enterprise Data Services at Empire Life
    Empire Life
    ------------------------------



  • 4.  RE: For the Snowflake Connector, How do you bring in relationships?

    Reltio Employee
    Posted 10-25-2021 10:01
    Sandro, 

    We have a separate match and merge table also will come, so that will be not fall into this entity relation interaction. We will have a match table and the table itself will be a view waiting for us we will get a view as well. You will have a match table which will tell what the potential matches are, and we will have a merge table which will tell what basis the merges this is happen, and each entity type, and entity URL submerge. So those are all available.

    ------------------------------
    Ganeshkumar Palanisamy
    ------------------------------