Move/Replicate Data from MySQL to BigQuery

[gabrielmemories]

My question is what would be the best practice to move or replicate the data that is in a MySQL database hosted on AWS that is being used as a "Warehouse" to BigQuery. I had read something about Datastream, but they also told me something with a Batch process. What would be the best option and if there is any example or guide for this.

[ms4446]

Thanks for the question. The preferred to way to replicate data and ensure data in sync with your MySQL database and your BigQuery instance is to use Datastream. For more information see the following links: 

https://cloud.google.com/datastream

https://cloud.google.com/datastream/docs/overview