Prevent Creation of Empty Files via dataflow ADF

Balasubramani T Mohanasundaram 1 Reputation point

hello, how to Prevent Creation of Empty Files via dataflow to sink destination.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,505 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 27,391 Reputation points MVP

    Hey, Can you please provide details about your source ? from which you are generating the file?

    In case if it is SQL database,
    You can switch to query mode in source of dataflow and check the count of query. If it is zero, throw error else provide output. As per my understanding there is no out of the box feature to validate it within copy activity.

    Or you can use a look up activity or script activity prior to dataflow to do the same

    0 comments No comments