Forum Discussion

Element115's avatar
Element115
Memorable Member
2 years ago
Solved

MISSING QUERY FEATURE from Lookup activity

QUESTION:   Is there a way, after pointing a pipeline Lookup activity to a lakehouse, to actually query said LH to get back a singleton?  For ex:  let's say you have a column named INDEX. You want ...
data engineering
  • Element115's avatar
    Element115
    2 years ago

    I found why the following T-SQL statement was not being processed correctly:

     

    SELECT MAX(stationId)
FROM dbo.EcoCount_Station

     

     

    Instead, if you add an alias, like so:

     

    SELECT MAX(stationId) AS result 
FROM dbo.EcoCount_Station

     

    then it works.

     

    This is the kind of stuff that an intelligent engine can auto add transparently and the user will see the activity work properly.  Plus, the GUI could pop up an advisory bubble notifying the user of how to specify the T-SQL statement while at the same time telling the user that it automatically did it for him. Not rocket science. 

     

    To be perfectly honest, I am so sick and tired of this BS, always trying to guess how we are supposed to enter config or SQL statements in the GUI.  I mean it's mindboggling that we are still at this a year after the so-called GA release of Fabric. And this is just basic functionality we are talking about, not landing a rocket on Mars.  ğŸ™ƒ  

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello Element115 ,

Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Element115 ,

    It is confirmed from internal team that it is as per the design.

    We're always looking for ways to improve. Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

     

    In the meantime,  if you are looking for a method to query the lakehouse they you can achieve a similar result using a script activity.

    Hope this helps. Please let me know if you have any further queries.

    • Element115's avatar
      Element115
      Memorable Member
      2 years ago

      By design!?!!!!!?????   What the hell kind of design is that? Can you please explain what is the intent of a Lookup activity?

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Element115 ,

        Similar to ADF, fabric also has capability to run queries on Azure SQL database connector when we use External Datastore option. Kindly check the below screenshot for reference. 

         

         

        However , in case you want to query the lakehouse tables, you need to use Script activity. Depending on the connector , features in lookup activity changes . So, kindly consider using Script activity .

        Thankyou