Query a lakehouse using LookUP Activity

[barkev_mahsered]

Currently we can only return a table when using a lakehouse in a lookup activity, make so we can query it, it would be so much easier and faster to do incremental copies. I am sure it is possible, because we can create an SQL connection to the Lakehouse and query it.

[garddolau]

Any update from MS on this one, there will be low of ideas around this subject to bring together