Migrate from Google Cloud

BigQuery and Dataproc to Databricks on Google Cloud

BigQuery, Dataproc, Dataflow

Cover illustration: BigQuery and Dataproc to Databricks on Google Cloud
Short answer

Moving from BigQuery, Dataproc and Dataflow to Databricks on Google Cloud brings SQL analytics, Spark, streaming and ML onto one platform with open table formats and unified governance, while data stays in your Google Cloud project.

What we move

BigQuery datasets and SQL, Dataproc Spark and Hive jobs, Dataflow pipelines, scheduled queries

Value after the move

  • Run Databricks on Google Cloud next to your data
  • Open formats that avoid lock-in to one engine
  • Unified governance across data, models and agents

How Google Cloud maps to Databricks

Each component has a clear target on the Databricks Data Intelligence Platform.

Google CloudDatabricks
BigQuery datasetsDelta or Iceberg tables in Cloud Storage, queried by Databricks SQL
BigQuery scheduled queriesLakeflow Jobs
Dataproc (Spark, Hive)Serverless or job compute
Dataflow pipelinesLakeflow Declarative Pipelines or Structured Streaming
Cloud ComposerLakeflow Jobs
Dataplex and Data CatalogUnity Catalog
Vertex AIMLflow, Model Serving and Agent Bricks

How we run the migration

  1. Assess

    Inventory every table, job, report and user. Map dependencies, find what is unused, and estimate effort and cost.

    Output: Migration assessment and business case
  2. Plan

    Design the target lakehouse, governance and security. Group workloads into waves by value and risk.

    Output: Target architecture and wave plan
  3. Convert

    Convert SQL and ETL with LakeBridge and our accelerators, then review and test the output.

    Output: Converted, tested code per wave
  4. Reconcile

    Run old and new side by side and compare results table by table until they match.

    Output: Signed-off reconciliation reports
  5. Cut over and optimize

    Move users in waves, retire the old system, then tune cost and performance.

    Output: Decommission plan and FinOps baseline

We use Databricks LakeBridge for profiling, code conversion and reconciliation, alongside our own accelerators and engineer review of every critical path.

Go deeper

FAQ

BigQuery and Dataproc to Databricks on Google Cloud: FAQ

Does Databricks run on Google Cloud?

Yes. Databricks runs on Google Cloud, so data does not need to leave your cloud.

What is the best first workload to migrate from BigQuery?

One business domain end to end, such as customer or finance. It proves the pattern and gives users a complete experience early.

Other migration paths