cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

User16869510359
by Esteemed Contributor
  • 746 Views
  • 1 replies
  • 0 kudos
  • 746 Views
  • 1 replies
  • 0 kudos
Latest Reply
User16869510359
Esteemed Contributor
  • 0 kudos

It's the use case that decides the use of Shallow clone or DEEP Clone Data is physically copied to the clone table in the case of a Deep clone. A deep clone is very useful to copy the data and have a backup of the data in another region/env. The typ...

  • 0 kudos
User16826992666
by Valued Contributor
  • 3807 Views
  • 1 replies
  • 0 kudos
  • 3807 Views
  • 1 replies
  • 0 kudos
Latest Reply
sajith_appukutt
Honored Contributor II
  • 0 kudos

Shallow clone: only duplicates the metadata of the table being cloned; the data files of the table itself are not copied. These clones are cheaper to create but are  not self-contained and depend on the source from which they were cloned as the sourc...

  • 0 kudos
User16826992666
by Valued Contributor
  • 955 Views
  • 1 replies
  • 0 kudos

Resolved! If I create a clone of a Delta table, does it stay in sync with the original table?

Basically wondering what happens to the clone when updates are made to the original Delta table. Will the changes apply to the cloned table as well?

  • 955 Views
  • 1 replies
  • 0 kudos
Latest Reply
sajith_appukutt
Honored Contributor II
  • 0 kudos

The clone is not a replica and so updates made to the original delta table wouldn't be applies to the clone. However, shallow clones reference data files in the source directory. If you run vacuum on the source table, clients will no longer be able t...

  • 0 kudos
Labels