Thank you for reading and for those kind words. I write in the hope to help other, and I'm happy it works!

Anyway, for your question, I will answer with another one. Why do you need data in BigQuery?

Indeed, it's a valid pattern to extract data from Cloud SQL and to store them in BigQuery for analytics. But most of the time, the most simple solution is to use Federated queries and allow BigQuery to query Cloud SQL.

But it requires a public IP on your Cloud SQL instance, not always accepted (and understood) by the security team, and you can't use that feature

As alternative, Datastream is a pretty good solution. And will be better soon (announcements are coming at Cloud Next 22)