Select query in azure adf pipeline -

how pass select query in azure adf pipeline fetching data file stored in azure blob.

for ex : file(test) in blob having single value

in adf pipeline in select query , shd fetch value table.

sqlquery:"select * emp id = (need fetch value test)"

is possible?

i not think possible directly within pipeline azure data factory not support variables in way. 1 other way of doing load file blob same database other query run, create stored proc joins two, call stored proc using stored proc activity, eg:

select *  emp  id = ( select id yourblobstagingtable ); 

hope makes sense.