Replicating data from MySQL to BigQuery using Dataflow template

[fguan]

Hello BQ users!

We recently published a step by step guide, which walks through how to set up data replication from MySQL database to BigQuery using Dataflow template. If you're interested in automating the process for faster insights, take a look at the tutorial and feel free to post any questions in this post!

https://cloud.google.com/blog/products/data-analytics/unlock-insights-faster-from-your-mysql-data-in...

[Willie_Turney · Accepted solution]

Thanks for posting this @fguan 👍 

[fguan]

We have published a step to step video tutorial guide  for your easy reference too! Post your questions here!

[rifkikarimr]

How about if the dataflow and MySQL (Cloud SQL) are running in different projects, I have to use vpc peering but it still doesn't work, currently I have to use the whitelist IP worker node on Cloud SQL, but I thought this was not the best practice. Is there any other alternative?