08-31-2021 01:36 AM
Hi All,
I need to give a s3 path dynamically from redshift metadata table in S3 File writer.
Because it has csv formatter before it, not able to give redshift execute and mapper to pass the value.
Any suggestion.
Regards,
Shrabanti
09-01-2021 01:21 PM
Hi @Shrabanti ,
You can add your S3 file path in the CSV Formatter as a custom binary header, and use it later for defining the path in the S3 File Writer.
BR,
Bojan