Skip to main content

Understanding Versions

Understanding The Versions And Change Detection​

In the timeline view, each thumbnail represents a version of change the metadata underwent. Here the version of the change is 297 with a summary of additions, deletions and updates. It means there were 296 other version of changes that occurred, but it is out of the scope of our tutorial.

  • Click on the thumbnail 297.
  • A detailed view appears below with all the changes that occurred.
  • Summary says there were 6 objects and 28 properties added. 0 deletions and 0 updates.
    • 1 database Organization was added.
    • 1 schema public was added to Organization database.
    • 4 tables were added to the public schema.
      • 1 table Inventory added with 3 columns, 2 constraints and 2 indexes.
      • 1 table Products added with 4 columns, 1 constraints and 1 index.
      • 1 table Sales added with 3 columns, 2 constraints and 2 indexes.
      • 1 table Warehouse added with 4 columns, 2 constraints and 2 index.
  • You can view the type of columns, names of constraints and indexes by clicking on the respective tabs under the header SOURCE VALUE.

The metadata timeline detection job runs in background at a scheduled frequency to detects changes in the metadata. The change if detected is assigned a version number, which then appears on the timeline the next time you visit it. Let's say there was a change detected by the job. This change will be assigned version 298.

  • Click on the thumbnail 298.
  • In the view below, you can see that 3 objects and 2 properties have been updated.
    • 1 database Organization was updated.
    • 1 schema public was updated in Organization database.
    • 1 table Inventory in public schema was updated.
      • A new column inventory_update_time was added to the Inventory table. It is in upper case for display purpose only.
      • 1 column available_quantity was updated to integer from number.
      • You can see the change under the headers SOURCE VALUE in green colour and TARGET VALUE in red colour.

In the next example a delete operation is captured in the metadata timeline version. It is version 299.

  • Click on the thumbnail 299.
  • In the view below, you can see that 3 objects have been update. 1 property have been deleted.
    • 1 database Organization was updated.
    • 1 schema public was updated in Organization database.
    • 1 table Warehouse in public schema was updated.
    • 1 column warehouse_location was deleted.
note

Any addition is highlighted in green colour, deletion in red colour. An update is an addition (green) followed by deletion (red).

Video Demonstration​