Create External Table option missing

Question

shrimper 0

Hello,

I am just exploring Synapse. I am not getting the option for "create external table". Am i missing something? User's image

-S

shrimper 0 Reputation points

2023-10-03T19:41:45.1+00:00

ah, I figured this out. The storage linked services created as blob instead of ADLS Gen 2.
Harishga 6,005 Reputation points Microsoft External Staff

2023-10-10T07:49:59.6566667+00:00

@shrimper Glad to know that your issue has been resolved. And thanks for sharing the solution, which might be beneficial to other community members reading this thread. Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others " @Nandan Hegde reposted your solution in case you'd like to accept the answer.
Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

1 answer

shrimper 0 Reputation points

2023-10-03T19:41:45.1+00:00

ah, I figured this out. The storage linked services created as blob instead of ADLS Gen 2.
Harishga 6,005 Reputation points Microsoft External Staff

2023-10-10T07:49:59.6566667+00:00

@shrimper Glad to know that your issue has been resolved. And thanks for sharing the solution, which might be beneficial to other community members reading this thread. Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others " @Nandan Hegde reposted your solution in case you'd like to accept the answer.
Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Answer 1

Nandan Hegde 36,716 MVP Volunteer Moderator

Hey,

To close this thread , reposting the solution you identified for your cause:

The linked service was created as Azure Blob rather than ADLS Gen 2