New in Migrations: Faster and More Predictable

2026-03-05 · Source: Databricks · Field: Technology & Digital — Data Science & Analytics, Artificial Intelligence & Machine Learning, Cloud Computing & IT Infrastructure · Depth: Intermediate, quick

Summary

Databricks has enhanced Lakebridge, a free, open data migration tool, with new features designed to automate and simplify the process of moving off legacy data warehouses to the Databricks Platform. Since its launch last summer, Lakebridge has been used by over 1,000 customers and partners. The latest advancements include more comprehensive assessment capabilities, AI-powered SQL conversion, and a new guided user experience. The assessment feature, now supporting Synapse, profiles existing environments by analyzing metadata to provide insights into system configurations, resource utilization, query patterns, and performance metrics, publishing these to a Databricks dashboard. The AI-powered code conversion translates proprietary SQL dialects like T-SQL, Redshift, Teradata, Oracle, and Snowflake into ANSI SQL, leveraging an LLM-driven approach to handle complex transformations. Additionally, a new desktop app offers a guided, visual experience for planning and executing migrations, featuring automated checks and simplified workspace connectivity.

Key takeaway

For CTOs and VP of Engineering overseeing data strategy, Lakebridge offers a structured approach to mitigate the risks and unpredictable timelines associated with legacy data warehouse migrations. Your teams can leverage its AI-powered SQL conversion and comprehensive assessment tools to gain predictable effort and cost estimates, accelerating your transition to the Databricks Platform and reducing manual rework.

Key insights

Lakebridge automates data warehouse migrations using AI-powered SQL conversion and comprehensive environment assessment.

Principles

• Automate complex, error-prone migration steps.
• Early visibility into migration scope reduces rework.

Method

Lakebridge assesses source environments, converts proprietary SQL dialects to ANSI SQL using LLMs, and provides a guided user interface for end-to-end migration execution.

In practice

• Use Lakebridge to profile Synapse environments.
• Employ the /migrate function for SQL conversion in Databricks notebooks.

Topics

• Data Warehouse Migration
• Databricks Lakebridge
• AI-powered SQL Conversion
• Large Language Models
• Data Assessment

Best for: CTO, VP of Engineering/Data, Data Engineer, MLOps Engineer, AI Architect

Related on AIssential

• 10 Data Warehouse Migration Myths Blocking AI-readiness (and Your Blueprint for Seamless Modernization) — Successful data warehouse migration prioritizes AI enablement and business value over just cost or SQL conversion.
• Operational databases: How they work and when to use them — Modern data applications require unified operational and analytical capabilities beyond traditional OLTP systems.
• How Yieldmo Cut Database Costs and Cloud Dependencies — Migrating from DynamoDB to ScyllaDB can halve database costs and enable multicloud flexibility for high-throughput, low-latency workloads.
• Databricks Series: Day 18 of 30: Predictive Optimization Is Changing What It Means to Be a Data… — Databricks' automation of tuning tasks is transforming the data engineer's role from manual optimization to higher-level responsibilities.
• Migrating from an on-premise data warehouse to a cloud data mesh architecture isn’t about lifting and shifting everything. It’s about making deliberate, domain-aware decisions on which fields earn their place in the new architecture. — Successful data mesh migration prioritizes field-level evaluation based on domain utility and cost, not bulk transfer.
• Databricks says it solved the decades-old data pipeline problem that's been slowing AI agents — Databricks unifies transactional and analytical data at the storage layer, enabling millisecond latency for AI agents.

Open in AIssential →

Editorial summary, takeaway, and curation by AIssential. Original article published by Databricks.