szymon_dybczak
Esteemed Contributor III

HI @nayan_wylde , @shanisolomonron 

I don't think it works in the way you've described. We can easily check this. Each time I execute following code I get new id:

%sql
CREATE OR REPLACE TABLE databricks_demo_ws.default.my_table (
  id int,
  name string
)

So, first time I've exectued above code I got id: f2a57c4-152b-46c4-9dd5-b1e945846d71

Then I execute above code second time. As you can see, no major schema changes occured but still I got completly new id: 641cacab-7175-4f44-98cc-fad9ba8aa66e

I think what they refer in docs as table identity is more related to catalog / metadata identity (not necessarily the same as the internal delta log id). Because all other things mentioned in documentation hold:

  • The table history is retained, and I can revert the table to an earlier version with the RESTORE command.
  • The operation is a single transaction, so there is never a time when the table doesn't exist.