databricks Platform · Updated Jul 16, 2026

Agentic Code Converter

Now in Beta for SQL migration projects.

What it does

The agentic code converter utilizes Genie Code to transform legacy SQL dialects, including T-SQL, Snowflake, Redshift, Oracle, BigQuery, and Teradata, into ANSI SQL suitable for Databricks. It operates within a migration project framework, where it analyzes source scripts, validates their syntax and semantic intent, and iteratively corrects errors before saving the results. This tool is designed to streamline the migration of workloads from traditional data warehouses to Databricks.

Why it matters

This feature significantly reduces the complexity and time required for organizations to migrate legacy SQL workloads to Databricks, enhancing productivity and minimizing migration risks. By automating the conversion process, teams can focus on higher-value tasks rather than manual code rewriting, ultimately leading to cost savings and improved operational efficiency.

Key capabilities

Multi-Dialect Support

Converts SQL from various legacy dialects to ANSI SQL.

Error Correction

Iteratively fixes syntax and semantic errors during conversion.

Migration Project Management

Organizes and tracks SQL migration efforts within a dedicated project.

Custom Skills

Allows users to create custom rules for specific conversion needs.

Prerequisites

Workspace admin must enable the agentic code 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.Converting SQL scripts from multiple sources in one project.Validating and correcting SQL syntax during migration.

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

Workspace → Migration Project → Genie Code → ANSI SQL Output

Get started

Upload Source Files

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

Create Migration Project

Set up a migration project to manage the conversion process.

Add Files to Project

Select and add the SQL files or folders to the migration project.

Run the Conversion

Select files and initiate the conversion process.

Review Conversion Results

Check the converted files for accuracy and make necessary adjustments.

Key takeaway

The agentic code converter simplifies the migration of legacy SQL to Databricks, enhancing efficiency and reducing manual effort.

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