Forum Discussion
Databricks notebooks migration to Fabric Notbooks
Hi Team, We are trying to migrate databricks notebooks to fabric notebooks and we face issues related to Fabric SQL incompatibilities. Suppose an update statement which runs inside a select state...
No direct tool exists yet to auto-convert Databricks notebooks to Fabric notebooks.
You can automate much of it by....
- Extracting SQL from notebooks (%%sql or spark.sql() calls).
- Using SQLGlot (open-source transpiler) to convert Databricks SQL -> T-SQL/Fabric SQL.
- Building rule-based fixes for common issues (e.g., UPDATE in SELECT -> MERGE or temp-table pattern).
- Batch-running the script to flag and patch incompatible SQL across all notebooks.
No microsoft provided tool yet, but a custom Python+SQLGlot pipeline is the best practical approach to reduce manual effort.