Hi @MGAutomation ,

If by local instance you mean SQL Server deployed on-premises or in your local PC then i's possible but you need to establish network connectivity.
So you would have to deploy your databricks workspace into customer-managed vpc and then establish  a connection between your SQL server and the Databricks virtual private cloud (VPC) using VPN or AWS Direct Connect.

The hardest part will be networking here. Once you establish connection then you can just use jdbc or odbc driver to read/write data from SQL Server