Databricks Agentic Code Converter transitions proprietary SQL to ANSI SQL in Beta
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.
https://www.databricks.com/blog/convert-proprietary-code-open-ansi-sql-agentic-code-converter-now-beta
Related releases
- Databricks `ai_transcribe()` SQL Function for Audio Transcription (Beta) Databricks Release Notes ·
- Databricks Lakebase Snapshots API (Beta) for Programmatic Management Databricks Release Notes ·
- Databricks Introduces Session Restore for Serverless Jobs in Public Preview Databricks Release Notes ·
- Announcing On-Demand State Repartitioning for Apache Spark Structured Streaming on Databricks Databricks Blog ·
- Databricks Genie now displays visualizations directly in Slack replies Databricks Release Notes ·
- Databricks Introduces Configurable Data Retention for System Tables (Beta) Databricks Release Notes ·