Meta data for cloned table
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-22-2024 03:13 AM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-22-2024 05:22 AM
Just type: DESCRIBE HISTORY <table_name>. It will tell you if it is a Deep or Shallow Clone. Cheers.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-25-2024 09:42 PM
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 .
India .