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.
4,927 questions
Azure Synapse: How do you set up blob storage file as Azure Synapse external table that can be replicated?
![](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(313.6, 88%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Tyler Clark
1
Reputation point
Hello,
In Azure Synapse, one of the more powerful features is setting up a Spark table and having it replicated to query it in SQL Serverless. This works great if you set up a file in the data lake as a Spark table, but if I set up an azure blob storage file as a Spark table, I get an error when querying it from SQL Serverless. I think this is because the SAS_Token is only stored based on the session. \
Is there a way to set up an Azure Blob Storage file as a Spark table that can be queried through SQL Serverless?
{count} votes
-
![](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(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee2020-11-14T00:06:24.117+00:00 Hello @Tyler Clark ,
Thanks for the ask and using the forum .
I am reaching out to the internal team to get more help on this . I will update you once I hear back from the team .
Thanks
Himanshu -
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
2020-11-24T17:55:01.72+00:00 Hello ,
This should work. What is the error you are getting ?
Note that Spark can work only with AAD auth and cannot use SAS tokens. Spark tables that access Azure storage using AAD will be replicated to Serverless and you should be able to query it.
Thanks
Himanshu -
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
2020-11-30T21:00:27.727+00:00 Hello @Tyler Clark ,
We have not heard back from you on this and was just following up ,if the issue is resolved .
In case if you have a resolution we request you to share that with the community .Thanks
Himanshu -
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
2020-12-02T19:54:20.967+00:00 Hello @Tyler Clark ,
We have not heard back from you on this yet and was just following up ,if the issue is resolved .
In case if you have a resolution we request you to share that with the community .Thanks
Himanshu -
Tyler Clark 1 Reputation point
2020-12-11T21:09:04.663+00:00 Hello,
I'm working on trying to get this set up with a managed identity. I'll comment when I've tried it.
Thanks,
Sign in to comment
Sign in to answer