Can we create composite primary key while exporting nodes to neo4j using Dataiku Neo4j plugin?
![Ans](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar19.png)
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 Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 317 Dataiker
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