Convert proprietary code to open ANSI SQL with Genie Code

Migrating from a legacy knowledge warehouse is a posh enterprise, requiring groups to research decades-old code, translate proprietary dialects, migrate large datasets, and reconcile variations between methods. Databricks is making it dramatically simpler emigrate workloads from legacy knowledge warehouses to the Lakehouse with Genie Code, Databricks’ AI coding agent.

We’re excited to announce the brand new agentic converter in Genie Code. The agentic code converter interprets proprietary dialects to open ANSI SQL, beginning with T-SQL, Snowflake, Redshift, Oracle, BigQuery, and Teradata. It transforms an information warehouse migration from a venture your workforce staffs and manages to 1 you configure, launch, and monitor.

Automated migration planning

To see how the agentic converter works in observe, we’ll stroll via a proof of idea changing a set of T-SQL saved procedures to ANSI SQL.

To start out the migration, we create a migration venture, a brand new characteristic in a Databricks workspace. Migration initiatives give groups a central hub to handle supply information, monitor conversion progress, and collaborate all through the migration. We identify our venture Migration Challenge – POC, set the supply dialect to T-SQL, the goal to ANSI SQL, and select a vacation spot folder for the transformed information. As soon as created, we are able to populate the venture with supply SQL information, which have been beforehand uploaded to the workspace. Every file seems within the venture with its file sort, traces of code, and migration standing:

Genie Code analyzes and scores every file’s complexity, surfacing an evaluation in the appropriate panel. In our instance, mixed_5cats_sp_string_agg.sql scores low complexity as a result of it comprises solely SQL options that map cleanly to ANSI SQL. For a full scale migration, groups can use the complexity rating to prioritize and sort out less complicated information first.

Genie Code additionally generates lineage, mapping each relationship between objects within the legacy property — tables, views, and saved procedures. The lineage graph reveals that sps_sp_update_from.sql and sps_sp_pivot.sql haven’t any shared dependencies, that means they are often safely migrated independently.

In a full-scale migration, complexity and lineage give groups a transparent image of what emigrate, in what order, and what wants to maneuver collectively.

Totally agentic code conversion

After analyzing the supply code, we are able to begin to convert code. After we click on Run, Genie Code analyzes every script’s T-SQL and launches swarms of subagents to transform information in parallel. Every subagent iteratively fixes errors, validating each syntax and semantic intent to make sure the transformed code retains the unique enterprise logic and efficiently parses.

As soon as full, the transformed information are written to the vacation spot folder and color-coded by standing. In our proof of idea, 6 of 8 information have been efficiently transformed. Nevertheless, mixed_5cats_sp_string_agg.sql and mixed_6cats_sp_string_agg.sql want additional evaluate. Viewing the appropriate panel, we are able to see the listing of to-do’s required to repair the script. Genie Code explains that the flagged saved procedures should be certified by a 3 half identify in Unity Catalog (catalog.schema.sp_string_agg).

By clicking on the file, we are able to open the native SQL editor to discover the side-by-side distinction. We will make the repair manually within the editor or codify a conversion rule by making a customized talent in Genie Code. After we’re able to run the complete migration, Genie Code will apply the rule, on this case giving saved procedures a 3 half identify in Unity Catalog, routinely throughout your complete codebase. Customized abilities are additionally helpful for broader customization, like conforming to an authorised ETL sample or following inner naming conventions.

For groups seeking to lift-and-shift, Databricks ships the complete suite of enterprise SQL options. Multi-Assertion Transactions, Temp Tables, and Saved Procedures — options generally utilized in legacy knowledge warehouses – are all out there in Databricks, so there is no have to re-engineer your logic to suit a brand new platform.

Get began with the Agentic Converter at this time

The agentic code converter is the following technology of information warehouse migration tooling, constructing on Lakebridge’s success at scale. Since its launch at Information and AI Summit 2025, Lakebridge’s conversion tooling has helped over a thousand clients undertake the Databricks lakehouse:

“Lakebridge made our migration to Databricks extra predictable and environment friendly. It dealt with the conversion of our legacy saved procedures into Spark Declarative Pipelines, which reduce down a whole lot of the handbook work and helped us transfer quicker towards a consolidated open Lakehouse.”—Shane Irons, Sr. Director of Info Administration

As a subsequent step, we’re increasing the agentic converter to assist widespread legacy ETL sources and new goal dialects. We additionally plan to convey knowledge migration and reconciliation into the migration venture expertise, with a local Lakeflow Join integration emigrate knowledge and automatic instruments to validate that migrated knowledge matches the supply earlier than cutover.

Able to migrate? Join together with your Databricks account workforce to evaluate your legacy property and check out the agentic code converter right here.