szymon_dybczak
Esteemed Contributor III

@swathiG , there are multiple ways. You can use ADF to transfer SQL tables and load them into data lake. Then you can work with them in datbricks SQL warehouse. 

If you want only query those tables you can use lakehouse federation: 

https://docs.databricks.com/en/query-federation/index.html