Automating CSV Import AuraDB

Neo4j Graph Platform
1

Hello,

I want to create an automated process to import CSV files to AuraDB. This means I cannot use AuraDB's data import tool as that requires manual work. I am thinking to use Cypher commands such as LOAD CSV or apoc.load.csv, however, both would require the CSV files to be stored in the import folder of the database. But since I am working with AuraDB instead of Neo4j Desktop, I cannot access the import folder.

I am wondering is there any way to use Cypher commands such as LOAD CSV or apoc.load.csv to import CSV files to AuraDB?

Thank you.

2

I encountered a similar issue, but I was able to partially resolve the problem with LOAD CSV.

According to this post, if the CSV is stored on a server like AWS S3, you can use a Python script to execute LOAD CSV.

However, I'm facing an issue where LOAD CSV is too slow for large datasets. It seems apoc.import would be faster, so I'd like to know how to import data into AuraDB using apoc.import.

3

It also supports reading the files from a hosted ftp, http, and S3 location.

Here is the description of the load csv procedure.

Is there a specific issue you need assistance with?

1 Like