Share via

Create External Table in Azure SQL DATABASE from ADLS Parquet files

BGO 46 Reputation points
2022-02-02T20:00:56.107+00:00

Hello,

Is it possible to create an external table in Azure SQL (not Synapse) based on the parquet file that is located on ADLS Gen2?

Azure SQL Database
Azure Files
Azure Files

An Azure service that offers file shares in the cloud.

Azure Data Lake Storage
Azure Data Lake Storage

An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.

0 comments

Answer accepted by question author

Nandan Hegde 36,886 Reputation points MVP Volunteer Moderator
2022-02-03T04:49:52.46+00:00

Hey,
External tables in synapse use Polybase feature to read files from blob whereas the external tables in Azure SQL are for elastic queries( to cross read data between databases) and not for reading a file.
But there are other ways like bulk insert, openrowset :
https://techcommunity.microsoft.com/t5/azure-sql-blog/loading-files-from-azure-blob-storage-into-azure-sql-database/ba-p/386133

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.