June 2025 Summaries

SnowConvert AI is Snowflake's AI-enhanced tool integrated into its existing SnowConvert solution, designed to assist in translating SQL code from legacy systems to Snowflake-compatible syntax. Highlighted at the 2025 Snowflake Summit, the tool emphasizes self-service migrations with a focus on code translation and developer experience, offering a VS Code-based AI tool to help users address SQL translation issues. However, SnowConvert AI lacks comprehensive features like data validation, orchestration, and support for complex workflows, making it less suitable for large-scale enterprise migrations. Unlike a full migration system, it primarily provides syntax-level assistance without ensuring data accuracy or automated end-to-end validation. While it supports SQL Server and offers AI-powered suggestions via Snowflake Cortex, users must manually review and correct translations using the Migration Assistant GUI. In contrast, Datafold's Migration Agent (DMA) is positioned as a more robust solution, ensuring complete data validation and transformation while being data warehouse agnostic, offering true automation for migrations.

Lakebridge is an open-source toolkit developed by Databricks for migrating enterprise workloads to Databricks SQL (DBSQL), primarily aimed at system integrators and consultants rather than end users. Originally known as BladeBridge before its acquisition and rebranding in 2024, Lakebridge requires comprehensive configuration knowledge and manual setup, with a focus on assisting Databricks' partner ecosystem. It offers schema-, column-, and row-level reconciliation but lacks comprehensive value-level data validation, and its static, rule-based translation may necessitate manual adjustments for complex logic. Unlike solutions like Datafold's Migration Agent, which provides end-to-end automation and AI-driven feedback loops for thorough data validation and parity, Lakebridge does not support modern transformation tools like dbt or Coalesce.io. Despite its limitations, Lakebridge is positioned as a migration accelerator to aid in transitioning legacy SQL and ETL workloads into the Databricks environment, though it may require external expertise for optimal execution.