How to load files recursively from s3 into redshift

One Star

How to load files recursively from s3 into redshift

I have different sub-folders in s3 bucket. How to pass filenames from tS3List to tS3Get then load to redshift? what to use as  key?
bucket structure is like:
bucket/text/filename-001
bucket/text/filename-002
bucket/text/filename-003
bucket/images/filename-001-images
bucket/images/filename-002-images
Moderator

Re: How to load files recursively from s3 into redshift

Hi,
For key prefix, you can enter the prefix of files to be listed. This way, only files with that prefix will be listed.
Here is the component reference:TalendHelpCenter:tS3List with a related scenario.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.