Loading shapefiles from/onto Amazon S3 using the Amazon s3 connectors

Rudresh

Hi everyone,

We are looking for a way to be able to read/write geospatial data (shapefiles in ,shp format) stored in an Amazon S3 bucket.

The issue we are currently facing is that the S3 connectors in the Alteryx designer can only read/write 4 type of file formats (.csv, .yxdb, .json, .avro). 

[Question]: Is there a way to be able to access .shp files stored on an S3 bucket without having to first convert them on our local machines?

Thank you

gabrielvilella

Hi @Rudresh, you can download from S3 using command line (Run Command tool). It should be something like this:

$ aws s3 cp s3://mybucket/test.txt test2.txt

 This article explains in more detail (it's for zip files but the command to download should be the same):

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Download-a-Zipped-Excel-File-from-an-Amazon-S3-Bucket/ta-p/36988 

I have seen cases where opening directly from the Run Command does not load all the files, on this case I'd recommend using a batch macro to read the files once you've downloaded them.