topic Re: Databricks Lakebridge: Azure SQL DB to Databricks (Error while import) in Data Engineering

Databricks Lakebridge: Azure SQL DB to Databricks (Error while import)

shubham007 — Tue, 02 Sep 2025 12:01:46 GMT

Hi community experts,

I am getting error "cannot import name 'recon' from 'databricks.labs.lakebridge.reconcile.execute'" importing modules as shown in attached screenshot. I am follwing steps as mentioned in your partner training module "Lakebridge for SQL Source System Migration". Please help to resolve this issue.

Re: Databricks Lakebridge: Azure SQL DB to Databricks (Error while import)

szymon_dybczak — Tue, 02 Sep 2025 12:13:03 GMT

Hi @shubham007 ,

They made refactoring to that module in last month so that's why it stopped working. Probably Lakebridge for SQL Source System Migration module was recorded before that change.

And why they made change? It is explained here:

Split recon execute into smaller modules (#1892) · databrickslabs/lakebridge@7caba7a · GitHub

So now the correct way to use this module is like this:

lakebridge/docs/lakebridge/docs/reconcile/index.mdx at 7caba7a3d6d96850f7b9662307ebdaad392bfc80 · databrickslabs/lakebridge · GitHub

from databricks.labs.lakebridge import __version__ from databricks.sdk import WorkspaceClient from databricks.labs.lakebridge.reconcile.trigger_recon_service import TriggerReconService from databricks.labs.lakebridge.reconcile.exception import ReconciliationException ws = WorkspaceClient(product="lakebridge", product_version=__version__) try: result = TriggerReconService.trigger_recon( ws = ws, spark = spark, # notebook spark session table_recon = table_recon, # previously created reconcile_config = reconcile_config # previously created ) print(result.recon_id) print(result) except ReconciliationException as e: recon_id = e.reconcile_output.recon_id print(f" Failed : {recon_id}") print(e) except Exception as e: print(e.with_traceback) raise e print(f"Exception : {str(e)}")

Re: Databricks Lakebridge: Azure SQL DB to Databricks (Error while import)

shubham007 — Thu, 04 Sep 2025 07:09:23 GMT

Hi community experts,

I am getting error while Data and Schema Validation with the Reconciler. As attached here screenshots. Please help resolve this issue.

Output:

Re: Databricks Lakebridge: Azure SQL DB to Databricks (Error while import)

szymon_dybczak — Thu, 04 Sep 2025 08:00:23 GMT

HI @shubham007 ,

Are you sure you configured it correctly?

Re: Databricks Lakebridge: Azure SQL DB to Databricks (Error while import)

shubham007 — Thu, 04 Sep 2025 09:42:43 GMT

Regarding which configuration ? I have created scope and secrets correctly. You mean about “databricks labs Lakebridge configure-reconcile” ?

Re: Databricks Lakebridge: Azure SQL DB to Databricks (Error while import)

szymon_dybczak — Thu, 04 Sep 2025 09:46:25 GMT

I think you have mistake in your config file. Do you have a NONE catalog? I guess you don't have, so something went wrong during configuration phase:
NONE.SalesLT.customer

Did you follow this guide?

Reconcile Guide | Lakebridge

Re: Databricks Lakebridge: Azure SQL DB to Databricks (Error while import)

shubham007 — Thu, 04 Sep 2025 10:01:11 GMT

I am following that guide only. My recon_config_file as below:

and given below parameters while configuring reconcile:

Re: Databricks Lakebridge: Azure SQL DB to Databricks (Error while import)

szymon_dybczak — Thu, 04 Sep 2025 10:00:56 GMT

Could you send me link to a guide you're using? I'll try to recreate your scenario then

Re: Databricks Lakebridge: Azure SQL DB to Databricks (Error while import)

shubham007 — Thu, 04 Sep 2025 10:13:16 GMT

https://partner-academy.databricks.com/learn/courses/4326/lakebridge-for-sql-source-system-migration/lessons/42687/data-and-schema-validation-with-the-reconciler

https://databrickslabs.github.io/lakebridge/docs/reconcile/

My Azure SQL DB:

connection string: jdbc:sqlserver://sqldb.database.windows.net:1433;database=sqldb;user=sqladmin@sqldb;password={your_password_here};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;

Target-Databricks:

here need to migrate tables:

Re: Databricks Lakebridge: Azure SQL DB to Databricks (Error while import)

shubham007 — Thu, 04 Sep 2025 11:31:15 GMT

Hi @szymon_dybczak , which type of .sql scripts are required for migration such as legacy metadata and INSERT scripts to populate data in respective tables ?