I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .
Issue: I've been working on something, but I can't get it to work. I seem to have found the issue, but I"m not able to fix it. I've isolated in a single run which I'll explain below:
I have a Delta table on ADLSv2 (based on one partition) that I want to convert partitioned parquet. I run this, but somehow I get one partition that has data and one that has not. I don't use no set partitioning and it seems ADF splits them up in two. The source Delta file has only one parquet in it.
Why is this happening?
For reference the pipeline run id: f5d4fede-285f-4e23-ac8c-454ff6c479fb
Hopefully someone can explain what's going wrong!
Solution: This question can be closed. Fixed it my self by adding a select between the source and the sink. Using a select you have more possibilities to set partitions.
Not the most ideal solution and I certainly see the cause as one of the many bugs in mapping data flows, but it is what it is.
If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.