The quickest and recommended method of loading a Synapse dedicated SQL pool; it doesn't need external tables or file formats.
Also called COPY INTO.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains COPY statement in context, with comparison tables and the common traps.
Terms in this definition
- Dedicated SQL pool
Massively parallel warehouse in Synapse, previously named SQL Data Warehouse, which spreads data across 60 distributions and runs no more than 128 queries at once.
- External
API Management virtual network mode in which the gateway stays public but can call private back ends inside the VNet.
Related terms
- BCP
Bulk copy utility run from the command line to load data into SQL Server and Azure SQL; it is slower than the COPY statement.
- Direct copy
Loading a Fabric warehouse by having the Copy activity call the COPY statement straight against Parquet or delimited text files held in Azure Blob Storage or ADLS Gen2, with no intermediate step. If the format or settings aren't supported, staged copy has to be used instead.
- PolyBase
Way of loading data into Azure Synapse Analytics by querying external tables. The COPY statement is the faster alternative.