Prevent Creation of Empty Files via dataflow ADF

Balasubramani T Mohanasundaram 1 Reputation point
2022-10-19T13:27:23.047+00:00

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.
10,964 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 32,831 Reputation points MVP
    2022-10-20T02:36:04.623+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.