Migrate from AWS data services

Redshift, EMR and Glue to Databricks on AWS

Redshift, EMR, Glue, Athena

Cover illustration: Redshift, EMR and Glue to Databricks on AWS
Short answer

Moving from Redshift, EMR and Glue to Databricks on AWS consolidates several data services into one governed lakehouse. Your data stays in your own S3 in open Delta and Iceberg tables, and ETL, SQL, ML and agents run on one platform under Unity Catalog.

What we move

Redshift schemas and SQL, EMR Spark jobs, Glue catalogs and ETL, Athena queries

Value after the move

  • Stay on AWS while consolidating several services into one platform
  • Open Delta and Iceberg tables in your own S3
  • Built-in AI, Genie and agents on the same data

How AWS data services maps to Databricks

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

AWS data servicesDatabricks
Amazon RedshiftDatabricks SQL serverless warehouses
Amazon EMR (Spark)Lakeflow Jobs on serverless compute
AWS Glue ETLLakeflow Declarative Pipelines
AWS Glue Data CatalogUnity Catalog (with federation during transition)
Amazon AthenaDatabricks SQL
Step Functions or MWAALakeflow Jobs
Amazon S3Stays in place, holding Delta and Iceberg tables

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

Redshift, EMR and Glue to Databricks on AWS: FAQ

Do we have to leave AWS to use Databricks?

No. Databricks runs inside your AWS account and keeps data in your own S3 buckets.

Can Redshift SQL be converted automatically?

Much of it can, using LakeBridge and our accelerators. Engineers then review and test the converted code, and every report is reconciled before users switch.

Other migration paths