Neo4j provides LOAD CSV cypher command to load data from CSV files into Neo4j or access CSV files via HTTPS, HTTP and FTP. But how do you load data from CSV files available on AWS S3 bucket as access to files requires login to AWS account and have file access? That is possible by making use of presign URL for the CSV file on S3 bucket.
We will quickly walk through on how to create a presign URL for a file on AWS S3 bucket.
We will need aws command line utility for it.
aws command line utility is installed, setup the aws command line using
aws configure command.
For this example the
actors.csv file is available in
rohank S3 bucket.
Run the below command to create the presign URL for
The command will create and output the following presign URL
Then use the URL to access the file from S3 bucket using LOAD CSV as