Copy Activity (Blob to SQL etc.)

 

ADF Monitoring & Logging

Copy Activity (Blob to SQL etc.)

Copy Activity in Azure Data Factory (ADF) or Synapse Pipelines is used to move data from a source to a destination (sink). It enables ETL (Extract, Transform, Load) workflows across various data stores, such as copying data from Azure Blob Storage to Azure SQL Database or other combinations like Amazon S3 to Azure Synapse.

The process involves:

ource: Define the input data source, such as Blob Storage (CSV, JSON, Parquet).


Sink: Define the output destination, like Azure SQL, Data Lake, Synapse, etc.Mappings: Specify column-to-column mappings (auto or manual).


Settings: Configure performance (parallelism, batch size) and fault tolerance.

Copy Activity supports both structured and unstructured data, and allows data transformation using Mapping Data Flows or pre/post-copy scripts. It can be triggered on a schedule, event, or pipeline run.

Key features:

Supports on-premises, cloud, and hybrid sources

Scalable and fault-tolerant

Compression, encoding, and format conversion

Monitoring and logging for debugging

Use cases include data migration, data integration, and big data pipelines. It's a key component in building modern data engineering solutions that require reliable, automated, and secure data movement.

Read More

ADF Monitoring & Logging

Copy Activity (Blob to SQL etc.)

Triggers and Scheduling

Mapping & Wrangling Data Flows

Visit Our Website

Quality Thought Institute in Hyderabad



Comments

Popular posts from this blog

What is Tosca and what is it used for?

Compute Engine (VMs)

What is Software Testing