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

[iBusinessBI]

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?

[v-cboorla-msft]

Hi @iBusinessBI 

Glad that your query got resolved.

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

[salvalcaraz · Accepted solution]

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

[cmsrc]

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.

[MattiaSaba]

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?