Azure synapse spark Create spark table using and location

Question

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?

Answer 1

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/"