Overview: SQL Server
statements2016 (13.x) and later versions
Azure
SQL Managed Instance
Analytics Platform System (PDW)
Warehouse in Microsoft Fabric
Creates an external table.
This article provides the syntax, arguments, remarks, permissions, and examples for whichever
SQL product you choose.
In the following row, select the product name you’re interested in, and only that product’s
information is displayed.
SQL Database
Fabric Data Warehouse
Fabric SQL database
Azure Synapse
Analytics
Analytics Platform
System (PDW)
This command creates an external table for PolyBase to access data stored in a Hadoop cluster
or Azure Blob Storage PolyBase external table that references data stored in a Hadoop cluster
or Azure Blob Storage.
: SQL Server 2016 (13.x) and later versions.
Use an external table with an external data source for PolyBase queries. External data sources
are used to establish connectivity and support these primary use cases: