Convert proprietary code to open ANSI SQL with Genie Code
Summary
- Now in Beta, the agentic code converter uses Genie Code to convert proprietary SQL to open ANSI SQL, launching swarms of parallel agents that iteratively convert code, validating syntax and semantic intent
- Create a migration project in your Databricks workspace to track progress, visualize lineage, and identify which objects need to move together
- SQL-to-SQL translation is supported for T-SQL, Snowflake, Redshift, Oracle, BigQuery, and Teradata
Migrating from a legacy data warehouse is a complex undertaking, requiring teams to analyze decades-old code, translate proprietary dialects, migrate massive datasets, and reconcile differences between systems. Databricks is making it dramatically easier to migrate workloads from legacy data warehouses to the Lakehouse with Genie Code, Databricks’ AI coding agent.
We are excited to announce the new agentic converter in Genie Code. The agentic code converter translates proprietary dialects to open ANSI SQL, starting with T-SQL, Snowflake, Redshift, Oracle, BigQuery, and Teradata. It transforms a data warehouse migration from a project your team staffs and manages to one you configure, launch, and monitor.
Automated migration planning
To start the migration, teams create a migration project in a Databricks workspace — a hub to manage source files, track conversion progress, and collaborate. Genie Code analyzes and scores each file’s complexity and generates lineage mapping relationships between tables, views, and stored procedures.
Fully agentic code conversion
When Run is clicked, Genie Code analyzes each script and launches swarms of subagents to convert files in parallel. Each subagent iteratively fixes errors, validating both syntax and semantic intent. Converted files are written to a destination folder and color-coded by status. Teams can open a side-by-side SQL editor diff and codify one-off fixes as reusable custom skills (conversion rules) applied across the entire codebase.
Databricks ships Multi-Statement Transactions, Temp Tables, and Stored Procedures so lift-and-shift migrations need not re-engineer logic for a new platform.
Context and roadmap
The agentic code converter builds on Lakebridge’s conversion tooling (launched at Data and AI Summit 2025), which has helped over a thousand customers. Next steps include support for common legacy ETL sources, new target dialects, and data migration/reconciliation via Lakeflow Connect.
InfoWorld coverage (Jul 30, 2026)
Analysts note deterministic transpilers (Morpheus, BladeBridge, Switch) handle syntax mapping well but get brittle on control-flow, cursors, dynamic SQL, and recursive CTEs — the ~10–15% of legacy code that consumes most manual remediation. Agentic conversion is better suited for stored procedures and complex business logic. Beta currently limits conversion jobs to batches of 300 files. Snowflake (SnowConvert) and Google Cloud (Gemini-powered DMS) offer competing migration tooling.