A word of caution for those exporting a dataframe from Databricks to a Azure's Synapse- when using the overwrite mode, Databricks will drop the existing table in SQL before re-creating it and writing the dataframe to it.