https://community.databricks.com/t5/warehousing-analytics/impact-of-overwriting-databricks-sql-tables-on-versioning/m-p/76710#M1427 <P>When changes are made to a Databricks SQL table, a new version is created. If changes to the table are made using Spark or Python in a notebook and the table is overwritten, will a new version be created, or will it remain as version number 0?</P> Thu, 04 Jul 2024 07:36:21 GMT Akshay_Petkar 2024-07-04T07:36:21Z https://community.databricks.com/t5/warehousing-analytics/impact-of-overwriting-databricks-sql-tables-on-versioning/m-p/76710#M1427 <P>When changes are made to a Databricks SQL table, a new version is created. If changes to the table are made using Spark or Python in a notebook and the table is overwritten, will a new version be created, or will it remain as version number 0?</P> Thu, 04 Jul 2024 07:36:21 GMT https://community.databricks.com/t5/warehousing-analytics/impact-of-overwriting-databricks-sql-tables-on-versioning/m-p/76710#M1427 Akshay_Petkar 2024-07-04T07:36:21Z https://community.databricks.com/t5/warehousing-analytics/impact-of-overwriting-databricks-sql-tables-on-versioning/m-p/76890#M1428 <P>When changes are made to a Databricks SQL table (Delta table) using Spark or Python in a notebook, and the table is overwritten, <STRONG>a new version will indeed be created</STRONG>. It will not remain as version number 0. Each overwrite operation increments the version number of the table.</P> Fri, 05 Jul 2024 10:18:36 GMT https://community.databricks.com/t5/warehousing-analytics/impact-of-overwriting-databricks-sql-tables-on-versioning/m-p/76890#M1428 Rishabh-Pandey 2024-07-05T10:18:36Z