Understand Schemas

Dataset and view schemas can be viewed by selecting the Schema tab on the page for the dataset. The dataset page can be accessed by selecting Data in the Okera menu to access the Data page, selecting the database in which the dataset is registered on the Databases tab of the Data page, and then selecting the dataset from the list of datasets registered to the selected database.

The column names in the data are listed on the Schema tab for a dataset or view. Each column’s type, any tags assigned the column, and an optional comment are also listed. Admins or users with certain permissions can tag columns and edit comments. To learn more about this, see Edit Dataset Metadata.

Column Access

The Access column on the far right of the schema indicates whether you have access to a column. A green checkmark in this column indicates that you have access to this column while a lock icon indicates that you do not.

Columns for which you do not have access will not appear when you preview the dataset. For more details about previewing, see Preview Datasets.

Partitioned Columns

A column name with a grey background indicates that this column is a partitioning column.

Complex Types

Complex types appear as STRUCT in the Type column of the Schema tab.