Schema of Views¶

The Schema pill contains information about the fields of the view.

The Schema pill shows information about the fields of the view¶

For each field, it provides:

• PK. The icon is showed if the field is a primary key.

• Its name.

• Its logical name. This column is only visible when the configuration option Allow logical names for view fields is enabled. If you have the proper permissions, you can edit the logical name clicking its icon.

• Its type.

• Its assigned tags. To navigate to the details of a tag, just click its name. This column is only visible when there are VDP tags imported.

• A description in plain text. At first, it is obtained from Virtual DataPort. However, if you have the proper permissions, you will see a icon next to the description. Click it and define a new description, which will be specific to the Data Catalog.

• Nullable. The icon is showed if the field can be null.

Optionally, three additional columns related to the native datasource field type can be displayed if “Additional columns” is checked.

• Source Type. The type of the field in the source. E.g. VARCHAR, NCHAR, INTEGER, BIGINT, etc.

• Type Size. Its meaning depends on the type of the field.

  • For fields of type text, it indicates the maximum length of the field.

  • For numeric types, the maximum precision.

  • For values without decimals (int and long), this number is 0.

• Type Decimals. The number of decimals for fields of type decimal, 0 otherwise.

If Field descriptions in the user’s language is enabled, you can edit a description for each language enabled for field descriptions. To delete a description for a language just leave it empty. If the description in the language of the user is empty, the default description will be shown instead.

Dialog to edit the description of a field for multiple languages¶