Google cloud sql export csv fails when contains nulls

Question

I'm exporting a table from my Mysql database in Cloud Sql with the command,

gcloud sql export csv INSTANCE URI --query = QUERY

I have the file in my bucket, but when I try to import into Bigquery it fails, I noticed that all nulls are replaced by "n,

not even close the quote.

I found that this is a known bug, https://cloud.google.com/sql/docs/mysql/known-issues

Someone has a temporary solution?

thanks a lot.

Answer 1

The fix for this issue is still currently being addressed by the Cloud SQL Team. You can stay update on this thread

If you have to use CSV, you can try using an SQL client to issue an import with the options you prefer (LOAD DATA LOCAL INFILE) instead of using the Cloud SQL import API