About Pipeline Query

[kye1]

Hi Team,

I met a problem that when I use Lookup from Fabric Pipeline, linking lakehouse and I can't find the "Query" even I choose Table.
The case is that I create a table to be the watermark to do increamental load but cant find "Query" when using Lookup in Pipeline.
Please help. Thank you guys.

Best Regards,
Kye

[v-tsaipranay · Accepted solution]

Hi @kye1crystal ,

Thank you for clarifying. The T-SQL Query option shown in your screenshot is only available in the Copy Data activity when using the Lakehouse SQL analytics endpoint.

For the Lookup activity, this option isn't supported with Lakehouse connections. Lookup can reference only Tables or Files, which is why you don't see the query textbox.

If you want to run a query as part of your Lookup logic, you can use the Azure SQL Database connector and connect it to the Lakehouse SQL analytics endpoint. This way, Lookup will support T-SQL queries.

I hope this explains the behavior.

Thank you.

[kye1crystal]

Thank you @v-tsaipranay 

[Srisakthi]

Hi @kye1 ,

There is an option in Copy activity , are you looking for something like this?

Regards,

Srisakthi

[kye1crystal]

Hi @Srisakthi  ,
Yes , I am looking for this T-SQL Query option in Look-up activity

[v-tsaipranay]

Hi @kye1 ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.

[kye1crystal]

Hi @v-tsaipranay ,
The priority of this job seems to lower. So I didn't continue. I will update when I keep finding something. Thanks.

[v-tsaipranay]

Hi @kye1 ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

Could you please let us know if the issue has been resolved? I wanted to check if you had the opportunity to review the information provided by  @NandanHegde and @tayloramy  . If you still require support, please let us know, we are happy to assist you.

Thank you.

[kye1crystal]

Thanks @tayloramy  and @NandanHegde. You guys do help me a lot

[NandanHegde]

Glad it was helpful 🙂

[NandanHegde]

You can use Azure SQL Db connector and connect to the lakehouse via SQL anlaytics endpoint and then use look up activity and query 

[tayloramy]

Hi @kye1, 

THe Lookup activity does not support queries for lakehouses, only Tables and Files. 

 I recommend you vote for this idea: Query a lakehouse using LookUP Activity - Microsoft Fabric Community

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.