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.
5,378 questions
ALDS Gen2 Blob storage container
![](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(172.8, 5%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Aamir Ali
1
Reputation point
Hi All,
One of my colleagues is facing this issue while creating a table using an ETL Tool,
The create table DDL is as follows:-
Please help as this is a pressing issue.
Azure Synapse Analytics
{count} votes
-
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator2021-09-15T07:22:33.187+00:00 Hi @Aamir Ali ,
Welcome to Microsoft Q&A Platform. Thank you for posting query here.
From error message it seems either file or folder to which you are pointing is missing or your data source doesn't have access for the file or folder.
- Could you please check which type of authentication you are using inside your data source credential object and make sure the identity used inside credential object has access to your storage and path.
- Could you please tell us which SQL pool you are using? Dedicated or Server less?
- What is the format of files on which you are trying to create external table?
-
Aamir Ali 1 Reputation point
2021-09-15T09:37:33.863+00:00 Hello Maheer,
I Thankyou for the prompt response will ask for the following points from my colleague and get back to you on this sooner.
-
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
2021-09-21T09:14:21.88+00:00 Hi @Aamir Ali ,
Could you please share if any updates as per above comments?
-
Aamir Ali 1 Reputation point
2021-09-22T11:00:29.013+00:00 Hello Maheer,
We haven't got a chance to test this, I will update you once I have something sooner. Thank you for the follow-up.
-
Aamir Ali 1 Reputation point
2021-09-22T11:01:57.673+00:00 Hello Maheer,
We did not get a chance to work on this. We will update you with the details once we get back to this issue.
Thank you for the follow-up -
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
2021-09-29T11:26:45.883+00:00 Hi @Aamir Ali ,
Any updates on this. Is issue resolved? If yes, Please feel free to post your resolution details.
Sign in to comment
Sign in to answer