Cloud SQL export to CSV then load to BigQuery

[Tay Ta]

Hi everyone

I am trying to export my data from Cloud SQL to CSV file storing in google cloud storage then load the file to BigQuery as external table.

The exporting is working well, the null value can be exported as "N or \N.

But seems like we don't have any null marker setting on BigQuery external table to tell BigQuery load the "N or \N to null value to my external table?

Thanks

[holoubi]

We already support a null marker that should do the job for the user. See https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv#csv-options

[kayen here]

Thanks for sharing. I am checking this link it is really useful for paragon data.