Skip to content

Commit f276c9a

Browse files
authored
Merge pull request #85650 from linda33wj/copy-perf-refactor
Refactor ADF copy perf article
2 parents c71511c + 665db15 commit f276c9a

File tree

5 files changed

+107
-228
lines changed

5 files changed

+107
-228
lines changed

articles/data-factory/connector-azure-sql-data-warehouse.md

+1-1
Original file line numberDiff line numberDiff line change
@@ -397,7 +397,7 @@ Learn more about how to use PolyBase to efficiently load SQL Data Warehouse in t
397397

398398
## Use PolyBase to load data into Azure SQL Data Warehouse
399399

400-
Using [PolyBase](https://docs.microsoft.com/sql/relational-databases/polybase/polybase-guide) is an efficient way to load a large amount of data into Azure SQL Data Warehouse with high throughput. You'll see a large gain in the throughput by using PolyBase instead of the default BULKINSERT mechanism. See [Performance reference](copy-activity-performance.md#performance-reference) for a detailed comparison. For a walkthrough with a use case, see [Load 1 TB into Azure SQL Data Warehouse](v1/data-factory-load-sql-data-warehouse.md).
400+
Using [PolyBase](https://docs.microsoft.com/sql/relational-databases/polybase/polybase-guide) is an efficient way to load a large amount of data into Azure SQL Data Warehouse with high throughput. You'll see a large gain in the throughput by using PolyBase instead of the default BULKINSERT mechanism. For a walkthrough with a use case, see [Load 1 TB into Azure SQL Data Warehouse](v1/data-factory-load-sql-data-warehouse.md).
401401
402402
* If your source data is in **Azure Blob, Azure Data Lake Storage Gen1 or Azure Data Lake Storage Gen2**, and the **format is PolyBase compatible**, you can use copy activity to directly invoke PolyBase to let Azure SQL Data Warehouse pull the data from source. For details, see **[Direct copy by using PolyBase](#direct-copy-by-using-polybase)**.
403403
* If your source data store and format isn't originally supported by PolyBase, use the **[Staged copy by using PolyBase](#staged-copy-by-using-polybase)** feature instead. The staged copy feature also provides you better throughput. It automatically converts the data into PolyBase-compatible format. And it stores the data in Azure Blob storage. It then loads the data into SQL Data Warehouse.

articles/data-factory/copy-activity-overview.md

+1-1
Original file line numberDiff line numberDiff line change
@@ -141,7 +141,7 @@ The following template of a copy activity contains an exhaustive list of support
141141

142142
## Monitoring
143143

144-
You can monitor the copy activity run on Azure Data Factory "Author & Monitor" UI or programmatically. You can then compare the performance and configuration of your scenario to Copy Activity's [performance reference](copy-activity-performance.md#performance-reference) from in-house testing.
144+
You can monitor the copy activity run on Azure Data Factory "Author & Monitor" UI or programmatically.
145145

146146
### Monitor visually
147147

0 commit comments

Comments
 (0)