Tools → Schema Version Compare

Overview

The 2025.7 release introduces a powerful Schema Version Compare tool that allows schema managers to easily review and track changes made to physical schemas over time. By selecting any two versions of a schema, you can perform a side-by-side comparison to quickly identify and highlight added, removed, or modified items or configurations.

Setup and configuration

A CMC or cloud administrator must enable the feature before you can use it.

1. Sign in to the Cluster Management Console (CMC).
2. Navigate to Clusters > <your_cluster> > Cluster Configurations > Tenant Configuration > Incorta Labs.
3. Turn on the Schema Compare toggle.
4. Select Save.

Accessing the tool

You can access the Schema Version Compare tool from the Schema Designer in several ways:

• Compare the current version with a previous version:
  1. On the Action bar, select Settings (gear icon), and then select Compare with.
  2. In the Compare dialog, select the version you want to compare, and then select Compare.
• Compare the current draft with the latest saved version before saving changes:
  1. After making updates in the Schema Designer, on the Action bar, select the arrow next to Save Changes.
  2. Select View changes.
• Compare any two versions from the Version History:
  1. On the Action bar, select Settings (gear icon) and then Version History.
  2. In the Version history drawer, select More Options (⋮ vertical ellipsis) for a specific version, and then select Compare with.
  3. In the Compare dialog, select the second version, and then select Compare.

Tool anatomy

• Title bar
• Schema objects list
• Differences pane

Title bar

• The Title bar displays the current schema name.
• Use the Search box to filter objects and columns by name.
• Select the Close button to exit the Schema Version Compare tool.

Schema objects list

This section displays the schema objects and columns of the two selected versions side by side.

• Objects with variations are listed at the top for quick access.
• Color-coded rows and the Status column symbols represent the variation type:
  • Rows of additional objects or columns in the first version (the one on the left side) are marked by a plus sign (+) and highlighted in green.
  • Rows of missing objects or columns (those that exist in the second version, but not in the first one) are marked by a minus sign (-) and highlighted in red.
  • Rows of items with different configurations or properties are marked by a not-equal sign (≠) and highlighted in yellow. Hover over the sign to see a summarized list of the differences.
• Select a row to expand or collapse the Differences pane.

Differences pane

The Differences pane provides detailed information about the differences for the selected item: schema, object, or column. It contains a group of tabs that vary according to the item type and properties. An orange circle next to the tab name indicates different property configurations.

For a description of the available tabs and properties, see Comparable elements.

Comparable elements

The tool can compare changes across a wide range of schema elements and properties, including:

• Schema Properties
• Object Properties
• Column Properties
• Datasets
• Joins
• Filters
• Queries

Schema Properties

The following are the tabs available for the schema:

• Properties: Displays the schema properties, such as the schema name, description, and owner
• Joins: Displays the joins defined in the schema for each version. All changes relative to the first schema version (on the left side) are highlighted to make them easy to spot: new joins are in green, missing joins are in red, and modified joins are in yellow.

Object Properties

The object properties vary according to the object type. The following are the tabs available for the different schema objects:

• Properties: Displays the object properties, which vary according to its type. Examples of the object's properties include the object name, source, load order, and advanced settings, such as partial loading conditions and data retention policies.
• Datasets: Is available for physical tables and materialized views (MVs) only and displays the dataset or MV configurations, such as the incremental query, the connector version, and the batch method. The properties of query-based tables and Analyzer tables include a link to display the object query and incremental query, if any..
• Joins: Displays the parent and child joins defined for this object in each version. All changes relative to the first version (on the left side) are highlighted to make them easy to spot: new joins are in green, missing joins are in red, and modified joins are in yellow
• Filters: Displays the runtime security filters applied to the selected object, whether regular or formula filters.

Column Properties

The available properties of columns include the column name, label, and function, in addition to the encryption property and data type. In the case of formula columns, you can view the formula.