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) &...
