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,152 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,330 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 29,886 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 No comments

0 additional answers

Sort by: Most helpful