How to consume the output of a (SQL) script in a pipeline in a data flow in order to join with data?

Copper Contributor

I'm new to Azure Synapse.

I'm using a (SQL) script in a pipeline to run a query retrieving data from multiple tables located in an Azure SQL Database and then wish to consume that data in a data flow where it will be joined with data pulled from another external database and undergo some transformations and aggregation before being saved to another database. How do I get the data flow to consume the data from the script activity? I can't seem to figure that out, and the documentation only goes on about other pipeline activities such as Lookup or Copy not data flows. I also don't see an option in the script activity as to where to save the actual output.

0 Replies