Data Dictionary

Displays the metadata of columns and tables in the analysis.

The Data Dictionary is accessed by clicking the Data Dictionary () icon in the View bar.

You can also access the Data Dictionary through the View tab of TRS.

Figure 1. Data Dictionary in the results pane of the TRS

Column Information

This section of the Data Dictionary contains information about the column metadata in the table.

Name
Displays the column name. The column name is a way of referring to the column internally in value expressions and selection expressions. For more information, see Columns.
Label
Displays the column label. The column label is different from the column name. For more information, see Columns.
Origin
Displays the origin of the column. Columns can be from the base table (Base), the linked table (Link), or be a computed column (Comp.)
Type
Displays the data type of the column. Data types govern how data is stored internally. There are four simple data types that represent how information is stored in the 1010data Insights Platform:
  • Integer
  • Big integer
  • Real (or decimal)
  • Text

See Data types for more information.

Indexed?
Displays Indexed if there is an index in the column.
Format
Displays the format of the column. Display formats control how values are displayed within columns in the 1010data Insights Platform. For example, a display format of type:num;width:5;dec:2 means that the column is formatted as numbers with a width of 5 and 2 decimal places.

See Display formats for more information.

Width
Displays the width of the column, or the number of characters a column can hold.
Fixed?
Displays Fixed if the column is fixed. Fixed columns do not move, regardless of how far the table is scrolled in either direction.
Description
Displays a description of the values in the column.

Structure

This section describes the basic structure of the table, such as its segmentation and where its data is stored.

Query Dependencies

This section contains information about the tables on which this query depends, such as the base table and any linked or merged tables.

Worksheet
The degree of nesting of the worksheet. The base table is the Top level.
Query dependency
The full path of the table on which the query depends.
Title of referenced table
The title of the table on which the query depends.

Prelinks

This section contains information about prelinks in the table, if any. A prelink is a precalculated link between two tables on a specific set of columns. A prelink improves the speed of linking larger tables together.

To create a prelink, you can use materialize="1" within the <link> operation. See <link> in the 1010data Reference Manual for more information.

Foreign table path
The path to the foreign table that is prelinked to the current table.
Local link columns
The column(s) in the current table that are prelinked.
Foreign link columns
The column(s) in the foreign table that are prelinked.
Timestamp
The time the prelink was created.