anuj GCP BigQuery, Uncategorized, Cloud Spanner

MySQL to BigQuery – Moving On Prem SQL Databases into GCP

A common use case is around utilizing on premises SQL Databases for Cloud Analytics. There's a couple of options here.

Leave the sources on premises

Create Linked External Data Sources for BigQuery. Use BigQuery as the query engine.

Migrate your data to Cloud SQL or

Migrate your data to Cloud Spanner on GCP

For a multi regional solution, Cloud Spanner is the best bet. Migrate your SQL data to Spanner and then use ETL (DataFlow preferably) to pull data into BigQuery.

anuj

I am passionate about getting cloud solutions right the first time. I help customers transition to the public cloud with the appropriate security controls and guardrails. GCP, AWS and Azure Security Specialist. <a href="https://calendly.com/anujvarma/google-cloud-architect-initial-consultation">Initial Consultation</a>

Leave a reply

Your email address will not be published. Required fields are marked *