Copy Delta File from one ADLS to another ADLS

Question

Hi Team,

I have Delta file in one ADLS and need to copy to another, can I copy it using ADF ?

Answer 1

Hi Sharukh Kundagol,

Thank you for posting query in Microsoft Q&A Platform.

If its Azure databricks Delta, then you can do by using Azure data bricks delta table connector dataset in Copy activity. But, If thats not the case, then you need to go with mapping dataflows only.
In mapping dataflows, under source transformation, use inline dataset and select format as delta and select your delta tables. Use select transformation to take only desired columns and then finally use sink transformation.

Hope this helps. Please let me know how it goes.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.

Answer 2

As you want to copy files as is, my guess is you can do it leveraging binary dataset in ADF

https://learn.microsoft.com/en-us/azure/data-factory/format-binary

Answer 3

Do you consider the Data Factory which is best suited for above use case?