I am experimenting with Data Flows in Azure Data Factory.
I have:
- Set up a LinkedService to a SQL Server db. This db only has 2 tables.
- The two tables are called "dummy_data_table1" and "dummy_data_table1" and are registered as Datasets
- The ADF is copying data from these 2 tables, and in the Data Flow they are called "source1" and "source2"
However, when I select a source, go to Source options, and change Input from Table to Query and enter a simple query, it returns 0 columns (there are 11 columns in dummy_data_table1). I suspect my syntax is wrong, but how should I change it?
Hopefully this screenshot will help.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…