Hi,

If you are using Azure SQL DB Managed instance, could you please file a support request with Azure team? This is to review any timeouts, perf issues on the backend.

Also, it seems like the timeout is coming from SQL Server which is closing the connection after some time.

You can possibly add below this in the JDBC connection string as a param.

;queryTimeout=7200

The below connector developed by Microsoft SQL team has some bulk load options to speed up large data loads. Please give it a try

https://github.com/microsoft/sql-spark-connector