What is more optimized way of writing delta table in a workflow, "append" or "overwrite"?

[hpant1]

What is more optimized way of writing delta table in a workflow which is running every hour, "append" or "overwrite"?

[Witold]

There's no "optimized way", as these are two different concepts, and depend on your use case: Overwrite  removes existing data, i.e. replaces it with new data, while append adds new data to your existing table.

[Kaniz_Fatma]

Hi @hpant1, Thanks for reaching out! Please review the response and let us know if it answers your question. Your feedback is valuable to us and the community.

If the response resolves your issue, kindly mark it as the accepted solution. This will help close the thread and assist others with similar queries.

We appreciate your participation and are here if you need further assistance!