Dynamically taking S3 path from metadata
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
5 REPLIES 5

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
