Cloud SQL to BigQuery Issue about null
Problem
CSV export does not format NULLs and newlines correctly When you export data as CSV using the Cloud SQL export feature, NULLs are exported as ”N, which can cause the CSV file to contain unbalanced quotation marks. Additionally, if your text data contains a newline character, a trailing quote mark is added at the end of the line.
https://gyazo.com/8491e5e245d3440aaf1c26e95321c658
Golang library
Solutions
"N → \N using SQL or sed
code:bash
sed 's/,"N,/,\\N,/g' | sed 's/,"N,/,\\N,/g' | sed 's/^"N,/\\N,/g' | sed 's/,"N$/,\\N/g'