cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamically taking S3 path from metadata

Shrabanti
New Contributor II

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.

Untitled

Regards,
Shrabanti

5 REPLIES 5

bojanvelevski
Valued Contributor

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.

image

image

BR,
Bojan