Introducing Azure Data Factory Copy Activity

Download this episode

Download Video

Download captions

Download Captions


The Azure Data Factory service is a fully managed service for composing data storage, processing, and movement services into streamlined, scalable, and reliable data production pipelines. You can use the Copy Activity in a pipeline to copy data from a source to a sink (destination) in a batch. The Copy Activity can be used in the following scenarios:

  • Ingress to Azure. In this scenario, data is copied from an on-premises data source (ex: SQL Server) to a Azure data store (ex: Azure blob, Azure table, or Azure SQL Database)
  • Egress from Azure. In this scenario, data is copied from Azure (ex: Azure blob, Azure table, or Azure SQL Database) to on-premises data marts and data warehouse (ex: SQL Server)
  • Azure-to-Azure copy. In this scenario, the data distributed across Azure data sources is aggregated into a centralized Azure data store. Examples: Azure table to Azure blob, Azure blob to Azure table, Azure Table to Azure SQL, Azure blob to Azure SQL.

[00:00] - Introducing Azure Data Factory Copy Activity
[00:43] - Sample 1-- Copy data from Azure Sql to Azure Blob .
[01:49] - Sample 2-- Copy data from On Premises Sql Server to Azure Blob . 

To learn more you can follow the useful links and participate in the Forum





Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.