What's the difference between mode("append") and mode("overwrite") on my Delta table

[jose_gonzalez]

I would like to know the difference between .mode("append") and .mode("overwrite") when writing my Delta table

[jose_gonzalez · Accepted solution]

Mode "append" atomically adds new data to an existing Delta table and "overwrite" atomically replaces all of the data in a table.