Azure synapse spark Create spark table using and location

sakuraime 2,276 Reputation points
2021-03-28T15:06:05.187+00:00

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?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,626 questions
No comments
{count} votes

Accepted answer
  1. Samara Soucy - MSFT 4,931 Reputation points
    2021-03-30T03:37:32.59+00:00

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


0 additional answers

Sort by: Most helpful