CSV Import: Overall Graph of Nodes and Relationships

[mansour_shams]

Hello,

I am reading through CSV import and so far see that one can import nodes and then through match commands to find and establish relationships. Just a few questions I have at this point. Is there any way to read the overall graph of nodes and relationships and have the relationships established? If so, where can I find the syntax with examples?

Also, if the CSV is not the right approach for reading the overall graph, then please advise of an alternative approach.

Thank you.

[lju]

Hi Mansour,

I'm not sure I quite understand your question, could you please provide an example/diagram?

Thanks!

[mansour_shams]

Let us say that I have 50 Nodes and 200 connections between these nodes. I would like to read in and establish in the graph (from a file having some form of syntax):

• Node Labels and Properties

• Relationship Labels and Properties

• From which Node to which Node each relationship is connecting

Thank you.

[lju]

Hi Mansour,

There isn't at the moment a way to strictly specify a DDL of sorts for your import, however, you do have a number of ways to consider importing data:

• Via LOAD CSV you can specify how each row relates to another. The reason you may see a lot of MATCH/MERGE could be to avoid eagarness (https://markhneedham.com/blog/2014/10/23/neo4j-cypher-avoiding-the-eager/)
• Via offline data import (only for initial loads): you'd lay out your flatfiles in a way to be picked up according to your desired structure
• The Neo4j ETL tool: You can specify how your relational to graph conversion: https://neo4j.com/labs/etl-tool/