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

jose_gonzalez
Databricks Employee
Databricks Employee

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

jose_gonzalez
Databricks Employee
Databricks Employee

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

View solution in original post