Writing data from Azure Databrick to Azure SQL Dat… – Databricks Community

Yes, @Marco37 , you are right that currently, federated queries in Databricks only support reading data from external sources like Azure SQL Database—writing data back is not supported through that connection.One practice I’m aware of for writing data from a Databricks notebook to an Azure SQL Database is to use a JDBC connection. This allows you to write a Spark DataFrame directly into an Azure SQL table.Another option is to write data to ADLS (Azure Data Lake Storage), and then use ADF (Azure Data Factory) to load the data onto the Azure SQL DB.

Hopefully, this helps you in your case.
Thanks!
@Sat_8 

Data Engineer