'Can we save the mount point in azure synapse

I have a question in Azure Synapse spark pool. Does anyone know how to save the mount point? I did create the mount point referencing it to ADLS. It goes deleted or not referenced once after session terminates.

I have used the same in Azure databricks, where we can create mount point once and use any number of times. I was looking at same kind of behavior in synapse as well.

mssparkutils.fs.mount( 
    "abfss://[email protected]/RawData", 
    "/mountraw", 
    {"linkedService":"LS_ADLS_Raw"} 
)

appreciate if anyone answers this? Thanks in advance.

azureazure-synapse


Solution 1:[1]

There is no exact solution for your requirement. This is possible in Databricks but not in Synapse.

As a workaround, you can use CREATE EXTERNAL TABLE AS SELECT statement to export tables to files in Azure storage.

Refer: CETAS with Synapse SQL.

Solution 2:[2]

Unfortunately, this feature is not yet available on Azure Synapse Analytics. Our product team is currently working on this feature.

At this moment we don't have exact ETA on when will this feature will be available. And we will update this thread once it's available.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 UtkarshPal-MT
Solution 2 CHEEKATLAPRADEEP-MSFT

Related Questions