Fabric Copy Data Activity is More Than Copy
Microsoft Fabric
Aug 11, 2023 7:30 AM

Fabric Copy Data Activity is More Than Copy

by HubSite 365 about Reza Rad (RADACAD) [MVP]

Founder | CEO @ RADACAD | Coach | Power BI Consultant | Author | Speaker | Regional Director | MVP

Data AnalyticsMicrosoft FabricLearning Selection

Copy Activity is one of the most commonly used activities in Microsoft Fabric’s Data Factory Pipeline. The Copy Activity copies the data from a source to a dest

Fabric Copy Data Activity is a feature extensively utilized in Microsoft Fabric's Data Factory Pipeline. It functions to copy data from a source to a destination, though it is not limited to merely copying. This feature is explained in detail, shedding light on what it is, its purpose, its functioning and configuration options available. To understand further, you can refer to the article on the link provided: radacad.com/fabric-data-factory-copy-ac…

  • Copy activity in Microsoft Fabric's Data Factory Pipeline is not only about copying.
  • It includes various other aspects like rationale, functionality, and configuration.
  • Copy Activity assists in transferring data from one point to another.
  • Better understanding of this feature can be drawn from the given article link.
Reza Rad delves deep into the functionalities and benefits of the Copy Activity feature within Microsoft Fabric's Data Factory Pipeline. While its basic functionality involves transferring data from one source to a destination, it is designed to accomplish much more.

Key Insights:

  • Microsoft Fabric:
    • Microsoft's holistic SaaS solution for Data Analytics. It merges multiple services and products to deliver a unified platform tailored for data analytics.
  • Data Factory:
    • Located within Fabric, this is the component tasked with data integration. It plays a crucial role in the processes of data extraction, transformation, and loading.
  • Data Pipeline:
    • A feature within Data Factory, the Data Pipeline governs the execution flow of various data tasks. These tasks can vary widely, from data copying to executing procedures based on preset conditions.
  • Role of Copy Activity:
    • Beyond mere data copying, this feature can integrate seamlessly with other tasks such as invoking stored procedures or within conditional operations. Given the destination, users may choose different methods for data copying, making this feature pivotal for optimizing data copying, especially with vast data sets.
  • ETL vs. ELT:
    • The traditional Extract, Transform, Load (ETL) methodology is being superseded in certain scenarios by the Extract, Load, Transform (ELT) approach. The latter emerges as more proficient in handling massive data as it prioritizes relocating data into a performance-centric system before initiating transformations. Azure Data Factory predominantly leans towards ELT.
  • Merits of Copy Activity:
    • Specifically crafted for the ELT approach, Copy Activity enables swift and efficient data copying devoid of transformations. It harnesses Microsoft Fabric's computational capabilities to streamline the process. Additionally, it offers the provision of data staging prior to copying, yielding benefits like data source isolation.
  • Utilizing Copy Activity:
    • Reza offers a step-by-step guide on harnessing the Copy Activity via the Data Factory workload embedded in Microsoft Fabric. The entire process is streamlined, with an assistant tool simplifying tasks such as source and destination selection, staging activation, and setting reviews. For those seeking more, advanced configurations are accessible for added customization.
  • Final Thoughts:
    • The Copy Activity enhances the data extraction and loading process, especially beneficial for voluminous datasets. It taps into extra computational capacities to optimize performance and is equipped with extensive settings for a personalized touch. While data copying constitutes just a fragment of data integration, with the exponential rise in data volume, it's often more pragmatic to first ingest and then transform the data. This is where the Copy Activity showcases its value.


Further Insight on Copy Activity

The Copy Activity in Microsoft Fabric's Data Factory Pipeline has a much broader function. It is designed not only to transfer data from a source to a destination but also provides a range of configuration options. It's not just a tool for simple copying; it can be tailor-fit to meet specific needs. It may also be used as a gateway for data migration, upgradation, and even data transformations. The given article link provides more comprehensive knowledge about this.

Learn about Fabric Copy Data Activity is More Than Copy

Fabric Copy Data Activity is much more than just a simple copy. It is an important activity used in Microsoft Fabric's Data Factory Pipeline. Copy Activity is used to copy data from one source to another. In this video, you will learn the purpose of Copy Activity, its working, and configuration options. You will also gain a deeper understanding of the Copy Activity and its advantages.

Copy Activity can be used to transfer data between on-premises and cloud sources. It can also be used to transform the data while it is being transferred. The data can be transformed using the built-in data transformation activities, or using custom code written in different languages such as .NET, Java, and Python.

Copy Activity also supports many popular data formats, such as CSV, JSON, Avro, and Parquet. It can also be used to copy data from various data sources such as SQL Server, Azure SQL Database, Azure Data Lake Store, Azure Blob Storage, and Azure Cosmos DB.

Copy Activity also supports the customizing of data transfer. You can set up different settings for different types of data, or even for individual files. You can also set up different security settings for different types of data.

Copy Activity also supports scheduling. You can set up a schedule to copy data from one source to another at regular intervals. You can also set up triggers to copy data when certain conditions are met.

Copy Activity also supports data streaming. You can configure Copy Activity to stream data in real time, which can be used for real-time analytics. You can also configure Copy Activity to buffer data, which can be used for batch processing.

Copy Activity also supports logging and monitoring. You can configure Copy Activity to log all the activities, errors, and warnings. You can also configure Copy Activity to monitor the data transfer and alert you if any issues arise.

Finally, Copy Activity also supports versioning. You can configure Copy Activity to keep track of different versions of data, which can be used for data recovery and auditing.

Thus, Copy Activity is much more than just a simple copy. It is a powerful tool that can be used to transfer, transform, and monitor data. It also supports scheduling, streaming, logging, and versioning.

More links on about Fabric Copy Data Activity is More Than Copy

How to copy data using copy activity - Microsoft Fabric
May 23, 2023 — Select Copy data on the canvas to open the Copy Assistant tool to get started. Or select Use copy assistant from the Copy data drop down list ...
Optimizing Copy Activity Data in Microsoft Fabric
Jul 9, 2023 — This blog talks about how you can optimize data in Microsoft Fabric after running a copy activity pipeline in data warehouse experience.
Getting Started with Data Pipelines in Fabric Data Factory
May 27, 2023 — Learn about Data Pipelines in Microsoft Fabric Data Factory. ... For example, there are activities such as Copy data or Dataflow.
Copy Activity vs Web Activity
Jul 31, 2023 — In Azure Data Factory, both Copy Activity and Web Activity can be used to connect to an API, but they serve different purposes and have ...
Azure Data Factory Resources
Dec 25, 2019 — Lookup activity in Azure Data Factory. Lookups are similar to copy data activities, except that you only get data from lookups. They have a ...
Copy files from SharePoint to Blob Storage using Azure Data ...
Oct 10, 2022 — Open ADF Studio. In Azure portal under Navigate select Resource groups and click on the resource group you created · Create a new pipeline.
Microsoft Fabric - Beyond Hype and Marketing!
Jun 1, 2023 — The answer to both questions is: YES. You don't need to copy the data from OneLake to the instance of the Analysis Services Tabular behind Power ...


Data Factory Pipeline, Copy Activity, Fabric Data Factory, Data Factory Copy Activity, Data Copy Activity, Copy Configuration