Forum Discussion

pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
9 months ago
Solved

Using script activity to query a lakehouse

Hi, I'm trying to use the script activity thinking to query a lakehouse in T-SQL language and I've noticed that it isn't possible to select a lakehouse. I think that a such feature could be very us...
General Question
pipelines
  • tayloramy's avatar
    tayloramy
    9 months ago

    Hi pmscorca, 

     

    I just tested and script activities can connect to a lakehouse SQL endpoint and select data. 

     

     Here is my test set up: 

     

    I created a script activity, and selected SQL Server database as the connection type. 

    I used the TSQL endpoint to connect: 

    I then wrote a simple select count(*) query to test it: 

     

    and that returned the proper result: 

     

     

    So if you're just trying to select data and not modify data, this works without issue. 

     

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

     

tayloramy's avatar
tayloramy
Icon for Super User rankSuper User
9 months ago

Hi pmscorca, 


Script activities can't connect to lakehouses currently, this isn't on the roadmap from what I can see.

 

I think you might be able to use the script activity to read from a lakehouse using the SQL endpoint, but I have not tried. 

 

I recommend posting an idea about this here: https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas

 

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

  • pmscorca's avatar
    pmscorca
    Icon for Post Prodigy rankPost Prodigy
    9 months ago

    Hi, thanks for your reply, but for script activity it isn't possible to select a lakehouse to query by T-SQL language.

    • tayloramy's avatar
      tayloramy
      Icon for Super User rankSuper User
      9 months ago

      Hi pmscorca, 

       

      I just tested and script activities can connect to a lakehouse SQL endpoint and select data. 

       

       Here is my test set up: 

       

      I created a script activity, and selected SQL Server database as the connection type. 

      I used the TSQL endpoint to connect: 

      I then wrote a simple select count(*) query to test it: 

       

      and that returned the proper result: 

       

       

      So if you're just trying to select data and not modify data, this works without issue. 

       

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

       

      • v-aatheeque's avatar
        v-aatheeque
        Icon for Community Support rankCommunity Support
        9 months ago

        Hi pmscorca 

        Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.