Hi @dipanjannet 

Please don’t use Query Federation for production ETL. Databricks’ own guidance says to ingest with managed Lakeflow connectors for scalable, low-latency pipelines, and use Lakehouse Federation/query federation mainly for ad-hoc analysis, discovery, and PoC/bake-off work—not as your primary ETL engine.

For more information, refer to this documentation here:

https://docs.databricks.com/aws/en/query-federation/database-federation?utm_source=chatgpt.com#query...

Here is information on the Lakeflow connector for SQL Server:
https://docs.databricks.com/aws/en/ingestion/lakeflow-connect/sql-server-pipeline