4 Replies Latest reply on Jan 4, 2018 5:07 AM by parikshit.shinge

    Download files from Amazon S3

    parikshit.shinge

      Hi All,

       

      My requirement is like follows:

       

      We have Amazon S3 database which acts as a directory. For examples, there are many folders on the S3 which again may have folder and then there are csv files. I have 100 users and each of the user has its location on S3. For e.g. for User1, s3://sales/user1 is the folder, for User2, s3://sales/user2 is the folder. There are csv files placed under these folders.

       

      In Tableau, I have a table like follows:

       

      UserLocation
      User1s3://sales/user1
      User2s3://sales/user2
      User3s3://sales/user3
      User4s3://sales/user4
      User5s3://sales/user5

       

      Now, whenever I click on any record, I want all the csv files placed on that user's location should get downloaded. These s3 paths are private and I don't a way to open these on web browser. Our S3 team use S3 Browser to access the locations.

       

      I know we can download file using URL action but it takes URL of that file with its extension. We can only download single file. Is there any way we can download bunch of files by specifying folder location?

      If not bunch of files, then is there any way i can download any random single file from the particular location?

       

      Thanks in advance!

       

      Regards,

      Parikshit