CODEWITHSUNDEEP
azure-data-factory
Randy Minder
Randy Minder

Reputation: 48522

ADF not picking up correct source columns in Copy Data task

In my Copy Data source, I am using a query as follows:

enter image description here

You can see that I'm adding two additional columns to the result set that are not part of the base table. When I go to the Mapping tab, those two columns do not appear in the source. I assume they should?

Upvotes: 0

Views: 483

Answers (1)

Fang Liu
Fang Liu

Reputation: 2363

This is because your query is an expression rather than a literal string. In this case, if you go to mapping tab and click import schemes, it actually won’t call API to retrieve your schema because the expressions need to be evaluated at runtime. So the UI will just use the schema you specified at source dataset schema tab. In your case, you could add your columns there.

Upvotes: 2

Related Questions