Can we create composite primary key while exporting nodes to neo4j using Dataiku Neo4j plugin?

Options
Ans
Ans Registered Posts: 1

Suppose I have a table with below columns:

emp_id | emp_name | emp_department | date_of_joining


I want to create a composite primary key named "ID" as

ID = emp_id + "_" + date_of_joining

I prepared my data by concatenating two columns and creating ID field. Then using ID field as a primary key in export nodes recipe. Please refer to the attachment.

Is there a more straight forward way to define which columns I need to use as a composite key and providing a name for it in recipe, rather than preparing the data manually?
Does neo4j handle this itself and provide an option like it does for defining primary key?

Answers

  • Sarina
    Sarina Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer Posts: 315 Dataiker
    Options

    Hi @Ans
    ,

    Using a prepare recipe to perform the column concatenation in order to generate the primary key prior to exporting to Neo4j will be the best solution. Please let us know if you have other questions.

    Thanks,
    Sarina

Setup Info
    Tags
      Help me…