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.

• go
• google-bigquery
• google-cloud-storage

Share Improve this question Follow edited Mar 12 at 9:16 Tri Pham asked Mar 12 at 9:14 Tri PhamTri Pham 2555 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

\r\n should be just fine.

BQ doc refers to RFC 4180, which says:

1. 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