Edit

Share via


Quickstart: Create a mapping data flow in Azure Data Factory and Azure Synapse Analytics

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!

Data flows are available in both Azure Data Factory pipelines and Azure Synapse Analytics pipelines. This article applies to mapping data flows. If you're new to transformations, refer to the introductory article Transform data using mapping data flows.

A mapping data flow provides a way to transform data at scale without any coding required. You can design a data transformation job in the data flow designer by constructing a series of transformations. Start with any number of source transformations, followed by data transformation steps. Then, complete your data flow with a sink to land your results in a destination.

Steps to create a new data flow

  1. Create a new V2 data factory by using the Azure portal.

  2. In the portal, go to your data factory. Select Overview, and then select the Open Azure Data Factory Studio tile.

    Screenshot that shows the tile for opening Azure Data Factory Studio in the Azure portal.

  3. In Azure Data Factory Studio, you can add sample data flows from the template gallery. To browse the gallery, go to the Author tab. Select the plus sign, and then choose Pipeline > Template gallery.

    Screenshot that shows selections for opening the template gallery in Azure Data Factory Studio.

  4. Filter by the Data flow category to choose from the available templates.

    Screenshot that shows the template gallery filtered for data flows.

You can also add data flows directly to your data factory without using a template. On the Author tab in Azure Data Factory Studio, select the plus sign, and then choose Data flow > Data flow.

Screenshot that shows selections for creating an empty data flow directly.