Datafactory Lookup Activity Error

Question

Hello, i have some pipeline for create SQL from API, like
CopyData-CopyData-CopyData-CopyData and save it to my DB.
Table for example:

Than in final i add Lookup action with some settings

UPDATE table_name
SET table_name.parameter = 0
WHERE table_name.parameter = 'Nothing'

And have this error:

But, despite the error, the Lookup action performs the necessary operations with the database for me and write it into my DB.
How i can resolve that? May be lookup can't be last operator in pipeline???

Answer 1

Hey,
It is expected that something be returned in lookup activity.
So you can add a query at the end as
Select '1'

UPDATE table_name
SET table_name.parameter = 0
WHERE table_name.parameter = 'Nothing' ;

Select '1'

Answer 2

Hi @Axell ,

According to official documentation, Lookup activity reads and returns the content of a configuration file or table. It also returns the result of executing a query or stored procedure.

This means, your query should always return some results back.

In your case, you are using Update query which simply update records in DB but nothing returns back to ADF. Hence, you see that error.
As @Nandan Hegde suggested, we can execute select '1' query at the end of update query to trick this and make sure something is returning to ADF. That in turn avoids error. Thank you.