Create External Table in Azure SQL DATABASE from ADLS Parquet files

BGO 21 Reputation points


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.
817 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.
929 questions
No comments
{count} votes

Accepted answer
  1. Nandan Hegde 22,196 Reputation points

    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 :

0 additional answers

Sort by: Most helpful