databricks Platform · Updated Jul 16, 2026

Lakebridge Agentic Converter

Now in Beta for SQL migration projects.

What it does

The Lakebridge Agentic Converter allows users to convert legacy SQL dialects, including T-SQL, Snowflake, Redshift, Oracle, BigQuery, and Teradata, into ANSI SQL suitable for Databricks. It utilizes Genie Code to analyze source scripts, validate their syntax and semantic intent, and iteratively correct errors before saving the converted results to a specified workspace folder. This tool is part of the broader Lakebridge migration framework designed to facilitate the transition of workloads to Databricks.

Why it matters

This feature streamlines the migration process for organizations transitioning from legacy SQL databases to Databricks, reducing the time and effort required to rewrite SQL code manually. By automating the conversion, it minimizes errors and enhances productivity, allowing data teams to focus on more strategic tasks rather than code translation. Businesses can leverage this tool to modernize their data infrastructure while ensuring compatibility with existing SQL scripts.

Key capabilities

Multi-Dialect Support

Converts SQL from various legacy dialects to ANSI SQL.

Error Correction

Iteratively fixes syntax and semantic errors during conversion.

Batch Processing

Supports conversion of up to 300 files in a single batch.

Custom Skills

Allows users to create custom rules for specific conversion needs.

Prerequisites

Workspace admin must enable the Lakebridge Agentic Converter from the Previews page.

Existing SQL files must be accessible in the workspace.

Workspace must meet Genie Code requirements.

Recommended use cases

Migrating legacy SQL workloads to Databricks.Automating the conversion of SQL scripts during data migration projects.Validating and correcting SQL syntax and semantics for compatibility with Databricks.

Limitations · remember

!A batch can contain a maximum of 300 files.

!A script can contain a maximum of 1,000 lines.

!Teradata BTEQ scripts are not yet supported.

Architecture

Lakebridge Agentic Converter → Genie Code → Migration Project Management → Databricks SQL

Get started

Upload Source Files

Use the workspace file browser or Databricks CLI to upload existing SQL files.

Create Migration Project

Set up a migration project in your workspace to manage the conversion.

Add Files to Project

Select and add the source files or folders to your migration project.

Run Conversion

Select files to convert and initiate the conversion process.

Review Results

Check the conversion results and validate the output in the SQL editor.

Key takeaway

The Lakebridge Agentic Converter simplifies the migration of legacy SQL to Databricks, enhancing efficiency and reducing manual coding efforts.

2026-07-16-lakebridge-agentic-converter-is-in-beta Generated by the Databricks Updates Agent · browse all updates