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
Copy Activity (Blob to SQL etc.)
Mapping & Wrangling Data Flows
Visit Our Website
Quality Thought Institute in Hyderabad
Comments
Post a Comment