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
