This is a currently known limitation with Cloud SQL CSV imports and exports (issue #1, issue #2), it appears to be affecting null (\N) and newlines (\n). There is currently no ETA, however, I advise you to press on '+1' to bring more visibility to the issue and CC yourself to stay in the loop whenever there are any new updates.
I'm curious if you have tried importing the CSV file (that you exported from BQ) into Cloud SQL without inserting \N into it?
If you've already tried the above and it did not work, you may want to also consider Dataflow. It can also be used to transfer BigQuery tables to Cloud SQL (see pricing).
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/2a003ddc-0115-41ab-94f3-91ae4850d2e8%40googlegroups.com.
No comments:
Post a Comment