Hello @amit kumar !
Welcome to Microsoft QnA!
When we execute Data Flow , Pipelines etc , the whole process contains a lot of other sub tasks :
Preparation meaning parsing the data flow, resolving dependencies, and preparing the execution plan.
Compute - Resources: it may take some time to start up the necessary resources. This is especially true if you're using on-demand compute resources, which can have a significant start-up time.
Execution: the actual running of the data flow, including source data retrieval, transformations, and finally sinking the data.
Resources Turning off: After execution, if the Time To Live (TTL) for the cluster has expired, or if the cluster is not set to remain active, it will be shut down.
Post-Processing: meaning logging, updating ADF metadata, and other necessary clean-up tasks
In fact the execution time for the sink in the data flow is a fraction of the overall process
I suggest to have a look
And this great article :
I hope this helps!
Kindly mark the answer as Accepted and Upvote in case it helped!