cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Help
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Meta data for cloned table

SeBaFlu
New Contributor

a week ago

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

0 Kudos
2 REPLIES 2

mark_ott
Databricks Employee
Databricks Employee

a week ago

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

User16309066414_1-1732281748548.png

 

 

 

0 Kudos

JissMathew
New Contributor II

Monday

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.



0 Kudos

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group
Announcements