topic Re: Using script activity to query a lakehouse in Pipelines

Using script activity to query a lakehouse

pmscorca — Fri, 07 Nov 2025 19:08:15 GMT

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 useful and a valid alternative respect to notebook.

Is querying a lakehouse by script activity planned in the Microsoft Fabric roadmap? Thanks

Re: Using script activity to query a lakehouse

tayloramy — Fri, 07 Nov 2025 21:05:42 GMT

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.

Re: Using script activity to query a lakehouse

pmscorca — Sun, 09 Nov 2025 19:36:42 GMT

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

Re: Using script activity to query a lakehouse

tayloramy — Sun, 09 Nov 2025 19:47:11 GMT

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.

Re: Using script activity to query a lakehouse

v-aatheeque — Wed, 12 Nov 2025 12:23:05 GMT

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.