Pricing example: Transform data in blob store with mapping data flows

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Tip

Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!

In this scenario, you want to transform data in Blob Store visually in ADF mapping data flows on an hourly schedule for 8 hours per day over 30 days.

The prices used in this example below are hypothetical and are not intended to imply exact actual pricing. Read/write and monitoring costs are not shown since they are typically negligible and will not impact overall costs significantly. Activity runs are also rounded to the nearest 1000 in pricing calculator estimates.

Refer to the Azure Pricing Calculator for more specific scenarios and to estimate your future costs to use the service.

Configuration

To accomplish the scenario, you need to create a pipeline with the following items:

• A Data Flow activity with the transformation logic.
• An input dataset for the data on Azure Storage.
• An output dataset for the data on Azure Storage.
• A schedule trigger to execute the pipeline every hour. When you want to run a pipeline, you can either trigger it immediately or schedule it. In addition to the pipeline itself, each trigger instance counts as a single Activity run.

Costs estimation

Operations	Types and Units
Run Pipeline	2 Activity runs per execution (1 for trigger run, 1 for activity runs) = 480 activity runs, rounded up since the calculator only allows increments of 1000.
Data Flow Assumptions: General purpose 16 vCore hours per execution = 10 min	10 min \ 60 min

Pricing calculator example

Total scenario pricing for 30 days: $175.88

Related content

• Pricing example: Copy data from AWS S3 to Azure Blob storage hourly for 30 days
• Pricing example: Copy data and transform with Azure Databricks hourly for 30 days
• Pricing example: Copy data and transform with dynamic parameters hourly for 30 days
• Pricing example: Run SSIS packages on Azure-SSIS integration runtime
• Pricing example: Using mapping data flow debug for a normal workday
• Pricing example: Data integration in Azure Data Factory Managed VNET
• Pricing example: Get delta data from SAP ECC via SAP CDC in mapping data flows