data loading to s3 in csv format is adding line breaker in rows, randomly to one column
0
we are fetching my data from pentaho , through snowflake, loading to s3. the data in pentaho is accurate ,but while it travels to s3 bucket , for a column, some portion of the data is randomly divided and send to next row, the data doesn't any new line (\n), for delimiter we use | as a symbol