ADF not picking up correct source columns in Copy Data task

Question

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

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?

Fang Liu · Accepted Answer · 2018-08-28 15:05:03Z

2

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.

answered Aug 28, 2018 at 15:05

Fang Liu

2,3612 gold badges15 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ADF not picking up correct source columns in Copy Data task

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related