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
  1. Nandan Hegde 36,716 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

    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.