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.