---
title: "Convert proprietary code to open ANSI SQL with Genie Code"
description: "Databricks introduces an agentic converter in Genie Code to translate proprietary warehouse dialects into open ANSI SQL, initially supporting T-SQL, Snowflake, Redshift, Oracle, BigQuery, and Teradata. Migration projects provide a workspace hub for source files, conversion status, complexity scoring, dependency lineage, and collaboration, helping teams prioritize work and identify scripts that can move independently. When launched, swarms of subagents convert files in parallel, iteratively fixing errors and validating syntax and semantic intent; in the proof-of-concept, six of eight files converted successfully. Two files required review because stored procedures needed three-part Unity Catalog names, which could be fixed manually or encoded as a custom Genie Code skill for reuse across the codebase. The post also notes that Databricks supports multi-statement transactions, temporary tables, and stored procedures, while planned additions include legacy ETL sources, new target dialects, data migration, and reconciliation."
---

# Convert proprietary code to open ANSI SQL with Genie Code

[Databricks](https://yomu.fyi/company/databricks) · Jonathan Brito · Jul 30, 2026

**Type:** Announcement

## Summary

Databricks introduces an agentic converter in Genie Code to translate proprietary warehouse dialects into open ANSI SQL, initially supporting T-SQL, Snowflake, Redshift, Oracle, BigQuery, and Teradata. Migration projects provide a workspace hub for source files, conversion status, complexity scoring, dependency lineage, and collaboration, helping teams prioritize work and identify scripts that can move independently. When launched, swarms of subagents convert files in parallel, iteratively fixing errors and validating syntax and semantic intent; in the proof-of-concept, six of eight files converted successfully. Two files required review because stored procedures needed three-part Unity Catalog names, which could be fixed manually or encoded as a custom Genie Code skill for reuse across the codebase. The post also notes that Databricks supports multi-statement transactions, temporary tables, and stored procedures, while planned additions include legacy ETL sources, new target dialects, data migration, and reconciliation.

## Context

Migrating from legacy data warehouses requires teams to analyze decades-old code, translate proprietary dialects, migrate large datasets, and reconcile differences between systems. The converter is presented as a way to make this work configurable, launchable, and monitorable rather than a project teams must staff and manage manually.

## Approach / What changed

Genie Code uses migration projects to organize source files and track progress, scores complexity, generates object lineage, and launches parallel subagents to convert scripts. The agents iteratively fix errors and validate syntax and semantic intent. Teams can review side-by-side differences, make manual fixes, or define reusable custom skills for conversion rules, ETL patterns, and naming conventions.

## Takeaways

- Migration projects expose file type, line count, migration status, complexity, and lineage so teams can prioritize simpler files and identify dependencies that can be migrated independently.
- The proof of concept converted 6 of 8 T-SQL files successfully; two required review because their stored procedures needed three-part Unity Catalog names.
- Custom Genie Code skills can apply a conversion rule across the codebase, while Databricks supports multi-statement transactions, temp tables, and stored procedures for lift-and-shift migrations.

**Tags:** [Databricks](https://yomu.fyi/topic/databricks), [SQL](https://yomu.fyi/topic/sql)

- Source: [Databricks](https://www.databricks.com/blog/convert-proprietary-code-open-ansi-sql-genie-code)
- Source URL: https://www.databricks.com/blog/convert-proprietary-code-open-ansi-sql-genie-code
- Ingested by Yomu: 2026-08-30T16:52:34.046Z

[Read original post](https://www.databricks.com/blog/convert-proprietary-code-open-ansi-sql-genie-code)