Azure SQL Database
An Azure relational database service.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Is it possible to create an external table in Azure SQL (not Synapse) based on the parquet file that is located on ADLS Gen2?
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 :