I'm using google.golang/api/bigquery/v2 package to import CSV files from GCS into BigQuery. The CSV file is using CRLF (\r\n) as the line separator.
Can BigQuery correctly parse CSV files that use CRLF (\r\n)?
I've searched the docs but couldn't find a clear statement about this.
I'm using google.golang./api/bigquery/v2 package to import CSV files from GCS into BigQuery. The CSV file is using CRLF (\r\n) as the line separator.
Can BigQuery correctly parse CSV files that use CRLF (\r\n)?
I've searched the docs but couldn't find a clear statement about this.
Share Improve this question edited Mar 12 at 9:16 Tri Pham asked Mar 12 at 9:14 Tri PhamTri Pham 255 bronze badges1 Answer
Reset to default 1\r\n should be just fine.
BQ doc refers to RFC 4180, which says:
- Each record is located on a separate line, delimited by a line break (CRLF).
The document in turn refers to RFC 2234, which defines:
CRLF = CR LF ; Internet standard newline