Explanation: 1) mount onto DBFS 2) read into data frame 3) transform data frame 4) specify temporary folder 5) write the results to table in in Azure Synapse https://docs.databricks.com/data/data-sources/azure/azure-datalake-gen2.html https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-extract-load-sql-data-warehouse