Redshift Unload to S3 End of Line Encoding Type

0

Hi

We currently have data produced in redshift which we are unloading as CSVs to s3 for it to be transferred via sFTP to an external client for processing.

In these CSV's, the line end is UNIX format, just LF, which doesn't work with the clients program. We instead want our CSVs to be produced in S3 having the DOS format, a CRLF line end instead.

Is this possible in the unload function? If not, is there a point in the pipeline where the conversion can happen easily? Maybe in the meta data of the s3 file, or with a conversion on a lambda function?

Thank you

1개 답변
0

The Redshift UNLOAD currently does not provide options for choosing LF or CRLF. But with S3 trigger you can invoke Lambda function to execute script for Unix to Dos conversion.

profile pictureAWS
답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠