Databricks Labs Remorph
Databricks Labs Remorph (version 0.9.1) is a toolkit designed for SQL code conversion and data reconciliation, aiming to accelerate data onboarding to Databricks from EDW, CDW, and other ETL sources. **This project is officially sunset and no longer maintained; users are advised to migrate to Databricks Labs Lakebridge for current migration tooling.** The last release for this specific PyPI package was in June 2025.
Warnings
- breaking This project is officially sunset and no longer maintained. No further updates, bug fixes, or support will be provided for Remorph. Users are strongly advised to migrate to Databricks Labs Lakebridge for current migration tooling.
- gotcha The `databricks-labs-remorph` PyPI package (version 0.9.1) is distinct from the later versions mentioned in the `databrickslabs/remorph` GitHub repository's release notes (e.g., v0.12.x), which are likely for its successor, Databricks Labs Lakebridge. Do not expect features or fixes described in recent GitHub releases to be present in the `databricks-labs-remorph` PyPI package.
- gotcha The Remorph tool requires Python 3.10 or 3.11. Using Python 3.12 is known to cause installation and operational issues.
- gotcha This project is provided 'AS-IS' for exploration only and is not formally supported by Databricks with Service Level Agreements (SLAs). Issues are reviewed as time permits, but no guarantees are made.
Install
-
pip install databricks-labs-remorph -
databricks labs install remorph
Quickstart
# This tool is primarily CLI-driven. First, ensure Databricks CLI is installed and configured.
# Then, use the 'databricks labs' command structure.
# Example: Transpiling a Snowflake SQL file to Databricks SQL
# Create a dummy SQL file for demonstration
with open('input.sql', 'w') as f:
f.write('SELECT CURRENT_TIMESTAMP() AS now_snowflake;')
# NOTE: This command assumes 'databricks labs' is configured and 'remorph' is installed via CLI.
# It will create 'output_folder/input.sql' with the converted SQL.
# The actual execution would happen in a shell:
# !databricks labs remorph transpile --input-sql input.sql --source snowflake --output-folder output_folder
print("To run, execute in your shell (after Databricks CLI setup and 'databricks labs install remorph'):")
print("databricks labs remorph transpile --input-sql input.sql --source snowflake --output-folder output_folder")
print("This will attempt to convert 'input.sql' (Snowflake dialect) to Databricks SQL.")
# To verify installation (after 'databricks labs install remorph'):
# !databricks labs remorph transpile --help