If your data is relatively small (say, 10M nodes and relationships), you can load it from a series of CSV files. The Cypher language's LOAD CSV function allows you to specify a URL from which to load data and customize the way that data is handled as its imported.
Connect using Neo4j Browser
The easiest way to run LOAD CSV against your AuraDB Instance is to launch the Neo4j Browser. On your Neo4j Cloud Console, click Query for your target AuraDB Instance.

This will open the Neo4j Browser for your target AuraDB Instance in a new window.
Enter your password to connect.

Once connected, you can execute Cypher against your AuraDB Instance.
Load CSV from a file?
The documentation for LOAD CSV talks a lot about loading data from a file on the database server. With AuraDB Instances, however, there is no server -- just a scalable Bolt endpoint. Here's where LOAD CSV FROM [url] comes in handy.
Loading CSVs from URLs
You can instruct LOAD CSV to retrieve files from FTP, HTTP, or HTTPS servers.
One particularly easy way to accomplish this is to place your CSV files in an Amazon AWS S3 Bucket and then make that Bucket into a static HTTP server. Amazon has some good documentation on this.
For examples of importing CSV from some common public-hosted locations(Github, Website, Google Sheet etc.) into a Cloud-hosted Neo4j Instance, please refer to the 'Neo4j Aura and Neo4j Sandbox' section of our Importing CSV Files article.
Comments
0 comments
Please sign in to leave a comment.