Implementing a data flow

Now that we have data in our data lake, let's transform the data and load it into our Synapse SQL pool that we created in Chapter 8, Provisioning and Implementing an Azure Synapse SQL Pool. As an example, we will create a pipeline that uses data flows to do a full load of the dimProduct table. You created the dimProduct table using the following SQL statement:

CREATE TABLE dbo.dimProduct
(
ProductKey                    int             NOT NULL
, SourceKey                   int             NOT NULL
, ProductName                 nvarchar(40) &...