To fully understand SQL syntax compatibility and transformation complexity before a migration, the Lakehouse Migration (LHM) center provides a feature to query syntax compatibility and transformation coverage. This feature provides a systematic overview of data type compatibility and transform rules, function compatibility and transformation mappings, and syntax compatibility with transformation examples between different dialects. This information helps explain syntax compatibility and transformation complexity to customers and internal teams during the pre-sales stage. It lets you quickly assess the technical feasibility of a migration and the refactoring workload before a project starts, which helps you create a migration plan.
1. Go to the query page
On the LHM website, you can access the syntax compatibility and transformation coverage query page from the SQL Transformation page.
In the navigation pane on the left, click Job Migration > SQL Transformation. On the page that appears, click Query Syntax Compatibility and Transformation Coverage on the right.
2. Query syntax compatibility and transformation coverage for a specific scenario
Select a Source Dialect and a Target Dialect for the query.
For example, consider a transformation from ClickHouse to Hologres. After you click Query, an overview of data type and function compatibility between ClickHouse and Hologres is displayed.
To learn about the detailed transform rules, view the details for Data Types, Functions, and Syntax in the right-side navigation pane.
The descriptions for function and syntax transformations include Test Samples that show the code before and after the transformation for each supported function and syntax.
3. Download the report
On the right side of the page, click Download to save the compatibility document for the current query. The report is provided in .txt format.
