topic Re: How to execute SQL query in Lakehouse as a part of a Pipeline run? in Pipelines

How to execute SQL query in Lakehouse as a part of a Pipeline run?

iBusinessBI — Sat, 30 Dec 2023 17:59:55 GMT

I have a pipeline which runs a Dataflow Gen 2. After this finishes, I need to run an SQL query that updates the Lakehouse table.

What Action do I use to run it?

Re: How to execute SQL query in Lakehouse as a part of a Pipeline run?

salvalcaraz — Sun, 31 Dec 2023 15:25:26 GMT

You can use the script activity within your pipeline 🙂
Transform data by using the Script activity - Azure Data Factory & Azure Synapse | Microsoft Learn

Re: How to execute SQL query in Lakehouse as a part of a Pipeline run?

v-cboorla-msft — Tue, 02 Jan 2024 05:17:32 GMT

Hi iBusinessBI

Glad that your query got resolved.

Please continue using Fabric Community for any help regarding your queries.

Re: How to execute SQL query in Lakehouse as a part of a Pipeline run?

MattiaSaba — Fri, 22 Nov 2024 12:18:59 GMT

It does not say that you can use the script activity for a lake house in your workspace.
If i want to query the delta tables that are in my Lake House how can i do it?

Re: How to execute SQL query in Lakehouse as a part of a Pipeline run?

cmsrc — Thu, 07 Aug 2025 00:10:25 GMT

That isn't a solution. Lakhouse linked service connections are not an option when adding a script activity in Azure Data Factory. This isn't solved and shouldn't be marked as solved.

Re: How to execute SQL query in Lakehouse as a part of a Pipeline run?

ritz — Fri, 07 Aug 2026 09:17:25 GMT

Hello this should not be accepted as a solution since it doesn't work as other comments have mentioned