LOAD CSV on private s3 files

load-csv

(Nitin Labhishetty) #1

Is there a way LOAD CSV can access a file on s3 without making it public?


(Benoit Simard) #2

I'm not an expert of S3, but you can mount locally the S3 bucket.
Or if you have an HTTP or FTP server, you can add the login/password in the url of the CSV file.


(Michael Hunger) #3

You can also generate temporary accessible s3 buckets or restrict them to source-ip's or such.

We don't support aws credentials in LOAD CSV. It could be something that could be added to APOC though.


(M. David Allen) #4

Without using S3 credentials, you can generate time-limited signed URLs using Amazon S3.

So while you can't use S3 creds as part of LOAD CSV in cypher, you can make the protected item public by creating a signed URL, and then load that.

Hope this helps.