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.