Forum Discussion

pmscorca's avatar
pmscorca
Kudo Kingpin
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
Super 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
Community 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.