Data Factory: Use a SQL Query to create a Data Source - Simple Talk

added by DotNetKicks
11/2/2021 3:58:04 PM


When we include a data source inside a data flow it always requests a dataset. The dataset, in turn, requires you to point to a table. A dataset can't be defined over a query, it needs an object on the linked service, which may be a table or view as you may notice on the image below.