This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 69%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
I want to write data from azure synapse analytics to Azure SMB File share
eg
I have a dataframe df and I want to write this data to a container
#df This is my datafra,e
df.write.csv("abfss://******@defg.dfs.core.windows.net/Customer",header=True)
but how can I do it in the file share
Hi , Greetings!
Please follow this to copy or move data
https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-file-storage?tabs=data-factory
Please accept if it helps , Thanks!
Can we do it through code from Azure Synapse Notebook (Apache Spark pool)
This is how we do it for containers
df.write.csv("abfss://******@defg.dfs.core.windows.net/Customer",header=True)
I want to do similar thing for file shares
Currently, Azure Synapse Analytics (formerly Azure SQL Data Warehouse) doesn't support writing data directly to Azure Files (SMB File Share) from Apache Spark pools in Synapse Notebooks using the same method (df.write.csv). The support for Azure Files is not as straightforward as writing to Azure Data Lake Storage Gen2 (ADLS Gen2) containers.
However, you can achieve writing data to Azure Files from Azure Synapse Analytics using an alternative approach. Here's a high-level approach:
Mount Azure File Share: Use the built-in feature of mounting an Azure File Share to your Apache Spark pool. This can be done through the Azure Synapse Studio UI or using code in a notebook.
Write Data: Once the file share is mounted, you can write data to it using the standard file I/O operations available in the language of your choice (e.g., Scala, Python) within the Synapse Notebook.
Here's an example of how you might write data to a mounted Azure File Share using Scala:
import org.apache.spark.sql.SaveMode
// Define your DataFrame
val df = spark.sql("SELECT * FROM your_table")
// Write DataFrame to a mounted Azure File Share
df.write
.mode(SaveMode.Overwrite) // Choose the appropriate save mode
.csv("/mnt/<your-mounted-file-share>/path/to/directory")
Replace <your-mounted-file-share> with the name of the mount point you created when mounting the Azure File Share.
Hi @Deepanshu katara ,
Can you also please share how to Mount Azure File Share in Azure Sypanse Spark pool?
Thanks!
Hi , please follow this doc https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/synapse-file-mount-api