Azure-Synapse exernal table on ADLS-Gen1

Vijay Sampath (Trianz) 66

Is it possible to build an External-Table on azure-synapse with the data stored in ADLS-Gen1 storage?

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2021-12-15T12:22:12.137+00:00
Hello @Vijay Sampath (Trianz) ,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.

1 answer

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2021-12-09T12:11:41.22+00:00
Hello @Vijay Sampath (Trianz) ,

Thanks for the question and using MS Q&A platform.

Yes, it is possible to build an External-Table on azure-synapse with the data stored in ADLS-Gen1 storage.

You can use external tables to:

Query Azure Blob Storage and Azure Data Lake Gen2 with Transact-SQL statements.

Store query results to files in Azure Blob Storage or Azure Data Lake Storage using CETAS.

Import data from Azure Blob Storage and Azure Data Lake Storage and store it in a dedicated SQL pool (only Hadoop tables in dedicated pool).

For more details, refer to External tables in dedicated SQL pool and serverless SQL pool.

Hope this will help. Please let us know if any further queries.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Want a reminder to come back and check responses? Here is how to subscribe to a notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
Please sign in to rate this answer.
Vijay Sampath (Trianz) 66 Reputation points

2021-12-10T00:10:17.383+00:00

Thanks @PRADEEPCHEEKATLA .
Can you please provide the steps to create an external table with data on ADLS-Gen1.
I am specifically interested in the Gen1.

Since Gen1 is coming to end of life in 2024, is there any restriction on creating new gen1 resources or using any of its features?

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2021-12-13T10:08:13.753+00:00

Hello @Vijay Sampath (Trianz) ,

The above document contains the detailed steps on how to create an external table on dedicated SQL pool. Could you please try and do let us know if you have any issues?

Yes, Azure Data Lake Gen1 will be retired on Feb 29, 2024 and currently new users cannot create any new Azure Data Lake Gen1 accounts with the help of opening a new support ticket.

For more details, refer to Retirement Announcement - Azure Data Lake Storage Gen1.

Hope this will helps.

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2021-12-14T10:48:28.217+00:00

Hello @Vijay Sampath (Trianz) ,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer