Discover all of the brand-new features and improvements to existing capabilities in the Dataiku 11.3 updateLET'S GO

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

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

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?

0 Kudos
1 Reply
SarinaS
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

0 Kudos

Setup info

?
Tags (1)
A banner prompting to get Dataiku