How to transform data using Data Flows
Learn how to transform data using Data Flows within Azure Data Factory. Data Flows are an no code/low code solution that allow us to connect to data sources, transform data then write that data to a data destination.
In this video we cover what transformations are available within Data Flows, work through an example where we pick up a file, apply an aggregate transformation followed by a derived column transformation to change data types then another derived column transformation to add new columns and finally write that data to a database.
00:00 Introduction
01:20 Get started with Data Flows
02:50 Add a Data Source
04:10 Data Flow Transformations
05:45 DISTINCT/AGGREGATE Transformation
09:30 Derived Column Transformation - convert data types
13:20 Derived Column Transformation - add columns
17:00 Add sink and mapping
18:30 Add Data Flow to Pipeline
19:20 Trigger a Pipeline
