Prevent Creation of Empty Files via dataflow ADF

Balasubramani T Mohanasundaram 1

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

ShaikMaheer-MSFT 38,466 Reputation points Microsoft Employee

2022-10-21T13:50:54.897+00:00

Hi @Balasubramani T Mohanasundaram ,

Just checking is below answer helps you? If yes, Please consider marking it as Accepted Answer. Accepted answers help community as well.

If below answer not helps, Please share more details on your implementation to understand what exactly dataflows is doing where its creating empty file.

1 answer

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
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer