ReleaseBytes
databricks Databricks Blog ·

Databricks Agentic Code Converter transitions proprietary SQL to ANSI SQL in Beta

blogaidatabrickspreviewengineer
feature announcement

Databricks Genie Code now includes an agentic code converter, available in Beta, designed to automate the migration of proprietary SQL dialects to open ANSI SQL. This tool uses parallel agents for iterative conversion and validation, aiming to simplify legacy data warehouse migrations for Databricks users. The converter supports T-SQL, Snowflake, Redshift, Oracle, BigQuery, and Teradata, with features like migration project management, code complexity analysis, and lineage tracking to guide the process.

  • →Agentic Code Converter available in Beta for SQL dialect migration
  • →Migration project management in Databricks workspace
  • →Custom skills for code conversion customization
  • →Code complexity scoring and lineage analysis for migration planning
  • →Enterprise SQL features maintained for lift-and-shift migrations
Features (3) ›
  • Agentic Code Converter available in Beta for SQL dialect migration

    Databricks' Genie Code introduces an agentic code converter, now in Beta, which uses swarms of parallel agents to translate proprietary SQL dialects (T-SQL, Snowflake, Redshift, Oracle, BigQuery, Teradata) to open ANSI SQL. The process involves iterative code conversion and validation of syntax and semantic intent.

  • Migration project management in Databricks workspace

    Users can create migration projects within their Databricks workspace to manage source files, track conversion progress, visualize object lineage, and identify dependencies. This central hub aids in organizing and monitoring the migration process.

  • Custom skills for code conversion customization

    Genie Code supports custom skills, enabling users to define conversion rules for specific requirements such as conforming to internal naming conventions or applying specific patterns, facilitating broader customization beyond standard translation.

Enhancements (1) ›
  • Code complexity scoring and lineage analysis for migration planning

    The agentic converter analyzes and scores code complexity for prioritization and generates lineage graphs to map relationships between data objects. This provides insights into migration order and identifies objects that need to be moved together.

Notes (1) ›
  • Enterprise SQL features maintained for lift-and-shift migrations

    Databricks continues to support enterprise SQL features like Multi-Statement Transactions, Temp Tables, and Stored Procedures, which are common in legacy data warehouses. This ensures that existing logic does not need re-engineering for migration.

Read the original announcement →

https://www.databricks.com/blog/convert-proprietary-code-open-ansi-sql-agentic-code-converter-now-beta

Related releases