Forum Discussion
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 useful and a valid alternative respect to notebook.
Is querying a lakehouse by script activity planned in the Microsoft Fabric roadmap? Thanks
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.
4 Replies
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.
Hi, thanks for your reply, but for script activity it isn't possible to select a lakehouse to query by T-SQL language.
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.
