Loading into an existing BigQuery table or creating a new table might result in "Error while reading data, error message: Too many values in row"


When you try to load into an existing Google BigQuery table or try to create a new table, an error might be returned when the following is true:

The error might look similar to the following:

ERROR: Error while executing bulk load: {Location: ""; Message: "Error while reading data, error message: Too many values in row starting at
       position: 0. Found 6 column(s) while expected 4."; Reason: "invalid"}


The workaround is to use the BL_DELIMITER= option to set a different delimiter than the default '07'x.