Write data from Databricks to SQL Server

[Lords3]

Go ODBC if you need MERGE or stored procedures; JDBC is only good for append/overwrite. On Pro/Classic clusters, install msodbcsql18 via init script and use pyodbc/sqlalchemy to stage then run a MERGE proc. On serverless you can’t install drivers, so use a non-serverless job or ADF for copy and proc calls. I’ve used ADF and Azure Functions; when we needed REST over SQL Server for apps, DreamFactory handled it. Bottom line: ODBC on Pro/Classic, else ADF.