Overview: SQL Server

statements
#tsql#statements

2016 (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: