A character variable with a missing value might be loaded as two double quotation marks ("") rather than a blank or null in a Google BigQuery table


When you create a Google BigQuery table in which the input data contains a character variable that is missing, two double quotation marks ("") might be loaded into the resulting string column instead of a blank or null. This issue occurs when any of the following is true:

There is no workaround for this issue.