topic Re: Meta data for cloned table in Administration & Architecture

Meta data for cloned table

SeBaFlu — Fri, 22 Nov 2024 11:13:04 GMT

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

Re: Meta data for cloned table

mark_ott — Fri, 22 Nov 2024 13:22:37 GMT

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

Re: Meta data for cloned table

JissMathew — Tue, 26 Nov 2024 05:42:32 GMT

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.