Using Databrick Bladebridge or Lakebridge for SQL Migration

dbr_data_engg
New Contributor III

Getting Transpile Error while executing command for Databrick Bladebridge or Lakebridge,


databricks labs lakebridge transpile --source-dialect mssql --input-source "<Path>/sample.sql" --output-folder "<Path>\output"


Error :

TranspileError(code=FAILURE, kind=PARSING, severity=ERROR, path='<path>\sample.sql', message='No module named 'databricks.labs.bladebridge.hasher.windows.pyarmor_runtime_000000.pyarmor_runtime'')

#bladebridge  #lakebridge

saurabh18cs
Honored Contributor III

try:
databricks labs lakebridge transpile --help

looks package is not installed properly can you reinstall databricks CLI

https://databrickslabs.github.io/lakebridge/docs/installation/#install-lakebridge

Br

saurabh

Abhimanyu
Databricks Partner

did you find a solution?

 

Satyam4u
New Contributor III

Looks like some dependency/runtime issue with LakeBridge installation on Windows.
pip uninstall databricks-labs-lakebridge -y
pip install databricks-labs-lakebridge

Also check Python version compatibility once. Python 3.10/3.11 worked better in my case.