Datasets Page

Click the Datasets navigation tab at the top to access the datasets page.

Use the Datasets page to browse, search, filter, preview, and star your accessible Okera datasets.

Any dataset where you have any level of access appears in this list. Datasets to which you have no access will not appear at all.

Searching and Filtering Datasets

Okera Datasets Search

At the top of the page, you can select datasets search and filter options:

  • Search box

    Search by dataset name. Any dataset name containing your input as a substring is displayed.


    You can quickly clear this box with the ESC key.

  • Filter by database multi-select box

    Filter the list to include only datasets in a particular database or set of databases.

  • Filter by User Tags multi-select box

    Filter the list to include only datasets that are tagged as selected.

  • Filter by Starred datasets checkbox

    Filter the list to show only datasets that you've starred.

  • Filter by Admin checkbox

    Filter the list to show only datasets that you are Admin on (you have ALL access to these datasets).

What does Admin mean?

If you have ALL access on a particular object (database or dataset), you are considered an admin for that object within Okera. You will also see an “Admin” tag on the dataset details panel.

Okera Admin Summary Card

For more about administrative usage, see Portal for Admins.

Dataset Details

To display a details panel for a given dataset, click its dataset card in the list. The details panel will appear on the right side of the screen.

Okera Dataset Details panel

This page contains:

  • The dataset's metadata, including:
  • Database name
  • Dataset name
  • Owner
  • Location
  • Description
  • Created (the date and time the dataset was created)
  • Metadata Changed (the date and time the metadata was last changed)
  • View Definition (if dataset is an external view)
  • Partitioning Columns (if dataset is partitioned)
  • The dataset schema described in full:
  • Total number of columns in the schema (next to 'Schema' tab)
  • Partitioning Column (if dataset is partitioned)
  • Each column in the dataset is shown, including:
    • Name
    • Type
    • Access (whether you have read-access to view the cells in this column)


If a column's name has a gray background, it is a partitioning column Okera partitioning field

Complex Types in the Schema

Complex types will be marked as “STRUCT” datatype in the schema. All the nested child elements will appear underneath with the parent elements greyed out. See also Previewing Complex types.

Okera Struct Datatype

Column Access

If your schema looks similar to the table below, you do not have access to every column in the dataset.

Okera See Groups

To display a list of groups with access to the data column, click See Groups associated with the applicable data column name. To gain access to that column's data, you must be added to one of these groups.

Starring Datasets

Clicking on the star next to the dataset name will add that dataset to your “Starred datasets” list. You can see a list of your recently starred datasets on the homepage.

Okera Starring Datasets

Dataset Action Menu

Okera Dataset Actions

At the top right of the dataset details, you will see an Action menu with these options:

Dataset Preview

To preview a dataset, click the Okera Preview Dataset Show Preview icon icon in the upper right of the details panel.

Okera Preview Dataset

  • Users can search by column header.

  • No more than 200 rows are shown (to view more, see "Dataset usage" below).

  • Column information with no access is not visible.

  • The modal can scroll vertically and horizontally.

  • If there are more than 60 columns, horizontal pagination will be available.


In order to speed up preview for large tables with many partitions, preview only shows results from the last partition. If you observe no results, please verify there is data in the last partition.

Previewing Complex Types

When previewing a table with complex types, the data will be displayed as an expandable JSON structure. Simply click the + to expand the cell and reveal the data values.

Okera Preview Complex types

Pagination for columns in Preview

If a table has many columns, it may be paginated. Use the horizontal pagination control in the top right of the table to traverse through all the columns.

Okera Preview Column Pagination

Column search in Preview

Tables with more than one column can be filtered by column name. Search for column names or select them directly from the filter to view specific columns.

Okera Preview Column Pagination

Get-Started Snippets

To start using a dataset, click Okera Usage Snippets Icon View usage icon on the upper right of its details panel.

Okera Get-Started snippets

Sections of different sample code are displayed, such as for Spark, Hive, Python, R, and CURL. Click the tab of your choice to retrieve integration code suitable for your application.