If you encounter the following ExternalResourceFailed
error while trying to load CSV this will help you in understanding the cause of the problem and possible fixes:
neo4j.exceptions.ClientError: {code: Neo.ClientError.Statement.ExternalResourceFailed} {message: Cannot load from URL 'file:///style_groups.csv': configuration property 'dbms.security.allow_csv_import_from_file_urls' is false}
This error indicates that you are trying to load a file directly from the local filesystem, which is not supported in Aura due to restricted access to the underlying systems. The "file://" URI scheme cannot be used for loading files from the local filesystem in Aura. Instead, Aura can only access remote HTTP(S) URLs for importing data. Therefore, any files that need to be imported must be stored in a remote location that the Aura instance can access.
To import CSV files in Aura, you can use the LOAD CSV FROM http://
. For more information and detailed instructions, please refer to this KB article: How do I load data from a CSV?
For examples of importing CSV from some common public-hosted locations(Github, Website, Google Sheets, 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.