Article DetailsDetailsHelp DetailsIf 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.For more secureway to handle your data you should consider using a pre-signed URL where you can better control access and make sure it is time bound as well. For GCP follow thisFor Azure follow thisFor AWS follow this See also: How do I define a LOAD CSV FIELDTERMINATOR in hexadecimal notationHow do I use LOAD CSV to update/set properties of existing nodesGetting `dbms.security.allow_csv_import_from_file_urls is false` error while loading CSV? InformationTitleHow do I load data from a CSV?Article Created Date3/15/2024, 10:57 PMURL Name360037063474-How-do-I-load-data-from-a-CSVLast Modified Date5/3/2024, 5:36 PM