For Blob Storage Synapse currently only supports SAS authentication. However, you can access the exact same storage from the Data Lake endpoint using pass through authentication. Make sure your Synapse account has the Storage Blob Data Contributor
role on the storage account and replace the blob storage location with the data lake one: " abfss://tables@Creat .dfs.core.windows.net/partitionfile/"
Azure synapse spark Create spark table using and location
sakuraime
2,321
Reputation points
In Azure synapse spark pool, I am going to create a spark table using parquet and location
like
%%sql
CREATE TABLE IF NOT EXISTS db.spark_table
USING PARQUET
LOCATION 'wasbs://tables@Creat .blob.core.windows.net/partitionfile/'
I found I can only authentication with Storage account key ..
HOw can I authenticate using Service principal ?
or can use AD Passthrough authentication?
Accepted answer
-
Samara Soucy - MSFT 5,051 Reputation points
2021-03-30T03:37:32.59+00:00