Meta data for cloned table

[SeBaFlu]

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]

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

[JissMathew]

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.