The only time your database table will be queried is when the data is acquired from the source transformation. After that, all of the computation is taking place on the ADF managed Spark environment.
Azure Data Factory CPU usage in dataflows

Alberto Font Escribano
21
Reputation points
Hi all,
We have a dataflow in Azure Data Factory that is transforming data from a table in a database. We create several activities like Derived Columns, Joins, Filters.. which all use this table as the source.
The question is if the CPU from that database is being used when we run this dataflow in the pipeline or if only the CPU from ADF is being used.
Any help on this is much appreciated.
Alberto
Accepted answer