Meta data for cloned table

SeBaFlu
New Contributor

Hi, guys!

How I can find out whether a table is cloned right now - hopefully by querying some meta data (information_schema or the like)?

Thanks! Sebastian

mark_ott
Databricks Employee
Databricks Employee

Just type:  DESCRIBE HISTORY <table_name>.  It will tell you if it is a Deep or Shallow Clone.  Cheers.

User16309066414_1-1732281748548.png

 

 

 

JissMathew
Valued Contributor

Hi @SeBaFlu ,

To determine whether a table in Databricks is a clone (created using Delta Lake's CREATE TABLE CLONE), you can use Delta Lake's metadata and DESCRIBE HISTORY command.



Jiss Mathew
India .