[google-cloud-sql-discuss] Re: Cloud SQL export to CSV then load to BigQuery

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

On Friday, December 17, 2021 at 2:06:19 AM UTC+5 holoubi wrote:

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

On Thursday, December 16, 2021 at 10:49:44 AM UTC-5 tay...@aeris.net wrote:

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/0680d6f4-d9a0-4420-8b4f-8b0b87429210n%40googlegroups.com.