Fabric Pipeline Query

[dhruvingandhi11]

Hi Team,

I’m facing an issue when using the Lookup activity in a Fabric Pipeline.
When connecting to a Lakehouse and selecting aTable, the “Query” option does not appear.

My use case is to create a table for watermarking in order to perform incremental loads, but I’m unable to use the Query option in the Lookup activity.

Could you please help me resolve this issue?

Thank you.

Best Regards,
Dhruvin

[Srisakthi · Accepted solution]

Hi @dhruvingandhi11 ,

Kindly refer this thread. 

https://community.fabric.microsoft.com/t5/Data-Engineering/About-Pipeline-Query/m-p/4881615#M13615

Regards,

Srisakthi