Environment details and comparison of environments

The list of created data models - environments (in the process of metadata import) can be seen in the details of each data source.

Environment details

The environment details page is divided into two parts, where the top part contains basic information about the environment and the bottom part contains the environment metadata.

An option to edit and reimport the data source information is available through the blue edit button on the right. The process is the same as creating an environment.

Figure 1: Environment details

Environment metadata is represented through a table that contains information about schemas, tables, and columns in the data model. The columns are not immediately visible. They can be seen for each table by using the View imported metadata details option on the right.

Every column row has information about the type of the column, whether it is a part of the primary key if it is nullable or read-only.

Figure 2: Environment metadata

Compare environments

If there are several different environments in one data source, a comparison can be made.

On the data source details screen, select the Compare environments option for the environment you want to compare with another one.

Figure 3: Compare environments

The comparison found that there are differences in the metadata related to the RegularTable table, which exists on both environments being compared, while the other tables exist only on the Default environment.

Figure 4: Differences

A closer look at the differences found shows that the LastName column exists only on the Test environment, while the Grade column exists on both environments being compared, but that there is a difference in the metadata. In order to determine exactly which difference is in question, this needs to be done in the database directly.

Figure 5: Differences in more detail