Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Copy multiple files with pattern from S3 bucket to local unix server

Hi All,

 

Need suggestion for below:

 

I need to copy multiple files from S3 bucket to local unix server. I am using TS3List to iterate each file and passing tS3list current key to tS3Get. My files are in subfolders under S3 bucket ("inbound_bucket/DW/Vendor"). If i am giving this whole bucket in S3list bucket, am getting error as "tS3List_1 - Failed to parse XML document with handler class com.amazonaws.services.s3.model.transform.XmlResponsesSaxParser$ListBucketHandler".

 

I tried below 2 options:

1. If am putting my files in top bucket itself -"inbound_bucket", then am able to copy into local unix server.

2. If am putting top bucket only - "inbound_bucket" in bucket and putting subfolders along with file pattern ("DW/Vendor/filepattern"), then files are getting copy in local along with S3 subfolders. This is what i get in local:

Lets say i have given unix local path in S3Get is /user/data. Then under this one new subfolder-/DW is getting created then another subfolder-/Vendor, then multiple files are getting copy-filepattern1.txt/filepattern2.txt.

 

Please suggest

 

Labels (4)
2 Replies
dipanjan93
Contributor
Contributor

Could you please show your job design as well as component settings?

Anonymous
Not applicable
Author

Am sorry but i can't show job design.

What am mentioning in bucket and key prefix i have mentioned in query itself