- 3842 Views
- 2 replies
- 4 kudos
We are trying to connect to an Azure SQL Server from Azure Databricks using JDBC, but have faced issues because our firewall blocks everything. We decided to whitelist IPs from the SQL Server side and add a public subnet to make the connection work. ...
- 3842 Views
- 2 replies
- 4 kudos
Latest Reply
Using subnets for Databricks connectivity is the correct thing to do. This way you ensure the resources (clusters) can connect to the SQL Database. We also recommend using NPIP (No Public IPs) so that there won't be any public ip associated with the...
1 More Replies
- 10489 Views
- 6 replies
- 3 kudos
Hi all,there is a random error when pushing data from Databricks to a Azure SQL Database.Anyone else also had this problem? Any ideas are appreciated.See stacktrace attached.Target: Azure SQL Database, Standard S6: 400 DTUsDatabricks Cluster config:"...
- 10489 Views
- 6 replies
- 3 kudos
Latest Reply
@Pearl Ubaru TLS 1.1 is already deprecated.Are there any concerns from your side to set TLS 1.2 in the connection string?
5 More Replies
- 10578 Views
- 4 replies
- 0 kudos
Hello.I want to know how to do an UPDATE on Azure SQL DataBase from Azure Databricks using PySpark.I know how to make query as SELECT and turn it into DataFrame, but how to send back some data (as UPDATE on rows)?I want to use build in pyspark istead...
- 10578 Views
- 4 replies
- 0 kudos
Latest Reply
This is discussed on Stack Overflow. As you see for Azure Synapse there is a way, but for a plain SQL database you will have to use some kind of driver like odbc/jdbc.
3 More Replies