Best way to programmatically import CSV data into AuraDB from Python scripts

Neo4j Graph Platform Aura & Cloud
1

I want to upload CSV files containing node and relationship information to my AuraDB instance.
However, from my research, the LOAD CSV method is not available in AuraDB, and apoc.import.csv is also not an option since I cannot edit the apoc.conf file.
The recommended approach seems to be using dump files for importing data into AuraDB.
While the Neo4j Data Importer is an option, I have excluded it since it requires a manual process.

My goal is to automatically import data into AuraDB from Python scripts. What would be the best practice for accomplishing this? I would appreciate any guidance on the recommended way to programmatically load data from CSV files into an AuraDB database instance using Python.

Thank you!

2

You can use load csv with hosted files on a ftp or http server.

3

LOAD CSV - Cypher Manual (neo4j.com)

From the following URL, it seems that "Not available on Aura" only applies to the case of "Import local files", while "Import from a remote location" is possible, right?

I haven't succeeded in executing it by placing the file on an FTP or HTTP server yet, but I'll try following your advice.

Thank you always for your detailed and kind responses.

1 Like
4

When specifying the file like 'https://{bucket}.s3.amazonaws.com/{folder}/nodes_xxx.csv', I was able to import the data into AuraDB via a CSV LOAD operation. Thank you again for your advice on this.

1 Like