LOAD CSV from local file failing with "Couldn't load the external resource", but valid file exists

Neo4j Graph Platform Import / Export
1

When trying to import a local CSV with LOAD CSV, I get an error:

neo4j@neo4j> LOAD CSV FROM "file:///artists.csv" AS row return row;
+-----+
| row |
+-----+
Couldn't load the external resource at: file:/var/lib/neo4j/import/artists.csv

artists.csv is straight from the LOAD CSV docs:

> cat /var/lib/neo4j/import/artists.csv
1,ABBA,1992
2,Roxette,1986
3,Europe,1979
4,The Cardigans,1992

And it seems to have the proper permissions:

> ls -la /var/lib/neo4j/import/artists.csv
-rw-r--r--. 1 neo4j neo4j 62 Jan  2 21:12 /var/lib/neo4j/import/artists.csv

Our config includes the following:

dbms.security.allow_csv_import_from_file_urls=true
server.directories.import=/var/lib/neo4j/import

Using a self-hosted cluster. We are able to load CSV's from URL's with no problems.

2

Make sure all servers in your cluster have /var/lib/neo4j/import/artists.csv. I usually end up configuring so the /import folder location is shared volume mount.

Or, most of the time I don't use load csv at all. I rather writhe a small data ingestion pipeline (spark or small python script).

3

Thank you, that's probably it. I was running LOAD CSV in a cypher shell on a specific cluster node. I didn't think the command would get ran on different node.