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.
1,343 questions
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.
1,527 questions
0 comments
Accepted answer
  1. Nandan Hegde 33,241 Reputation points MVP
    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 Answers by the question author, which helps users to know the answer solved the author's problem.