Send UPDATE from Databricks to Azure SQL DataBase

LukaszJ
Contributor III

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 of some pyodbc or something else.

Best Regards,

Łukasz