sajith_appukutt
Databricks Employee
Databricks Employee

Shallow Clones are really useful for short-lived use cases such as testing and experimentation . It duplicates the metadata from the source table - and any new data added would go to the location specified while creating the shallow table.

>Is the data written back to the original source file location?

No, you'd have to write code to explicitly MERGE the data back to source if that is desires.

View solution in original post