Forum Discussion

kye1's avatar
kye1
New Member
8 months ago
Solved

About Pipeline Query

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 ...
data engineering
Data Pipeline
Lakehouse
  • Anonymous's avatar
    Anonymous
    8 months ago

    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.

Anonymous's avatar
Anonymous
Not applicable
8 months ago

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's avatar
    kye1crystal
    Frequent Visitor
    8 months ago

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