Data product dashboard#

Data products are sortable, searchable, and filterable in the Dashboard pane. The filters work together to further refine search results.

The data products dashboard can present data products in a tile or list view, displaying the following:

  • Title

  • Status

  • Bookmark

  • Summary

  • Rating

  • Creator

You can also create a new data product from the dashboard by clicking the Create data product button.

Note

If your organization uses access control such as SEP’s built-in access control or Apache Ranger, you can only see the data products you are allowed to access. You can only create a data product if you have been granted Create privileges within the domain of interest.

Bookmarks#

For any data product, click the bookmark bookmark icon to add it to your list of favorites. Bookmarked data products always appear at the top of the list of data products, even when other sorting and filtering options are used. When cloning a data product, bookmarks are not copied from the cloned data product.

Sort data products#

Data products can be sorted by the following by using the Sort dropdown in tile view:

  • A-Z or Z-A by title

  • Descending or ascending by creation date

  • Alphabetical by status

Note

In tile view, bookmarked data products always appear at the top of the dashboard even when other sorting and filtering options have been used that preclude them from appearing as a top result.

In list view, clicking on the following column headers sorts by that column:

  • Bookmark

  • Data Product (title)

  • Created by

  • Date

  • Status

Data domains filter#

Your organization has many data domains, represented by people organized around a common business purpose, such as sales, marketing, or user engagement. Data products creators can assign data products to a domain. Use the Filter by domain drop down to filter the displayed data products for a particular domain.

Tags filter#

You can assign one or more tags to the data products that they create. Tags can be new or existing. Use the Tags drop down to select one or more tags to filter the displayed data products.

Search for data products#

The search field allows you to search on a string. Title and description text are searched.

Data product ratings#

You can view, add, edit, or remove a data product rating from its tile or Overview pane by clicking on its rating. Each applied rating is between one and five stars, and the displayed rating is an average of all ratings.

After clicking on the rating, a dialog appears. In this dialog, you can add a rating for the first time or change a previous rating by clicking on the appropriate number of stars. You can also remove your rating altogether by clicking Delete my rating. Click Update rating to submit your changes.

When cloning a data product, ratings are not copied from the cloned data product.

View or edit a data product#

In the Data products home screen, click on a tile to view a data product in the Data product details screen.

Overview pane#

In the Overview pane, you can browse the following information about a data product:

  • Catalog

  • Summary

  • Metrics - Queries and users in the last 7 and 30 completed days

  • Description

  • List of datasets

Each item in the list of datasets can expand and collapse. The expanded view shows a summary of the columns in the dataset, including:

  • A short description

  • View name to be used in queries

  • Date last updated

  • Column information

For each column, the following information is provided:

  • Column name

  • Data type

  • Column description (if available)

The list of datasets can be filtered by selecting and unselecting the VIEWS and MATERIALIZED VIEWS buttons above the list.

Usage examples pane#

The Usage examples pane allows you to view previously provided SQL usage examples for a data product, as well as adding new examples.

Each example usage contains a short explanatory text as well as the SELECT statement.

The SELECT statements can be copied for use in the Query data pane using the copy icon in the text box.

To create a new usage example:

  1. Click the + usage example button.

  2. Enter a short descriptive text and the SELECT statement.

  3. Click Save.

Discussion pane#

The Discussion pane allows users to discuss a particular data product. Markdown is supported, including the use of block quotes for replies. Comments can be liked and unliked. Users can edit and delete their own comments, and reply directly to existing comments.

Edit a data product#

Click the Edit button available in the ellipsis menu for a data product to enter its Update data product screen. This workflow is similar to the workflow for creating a data product, except not all fields are editable for everyone.

Note

If your organization uses access control such as SEP’s built-in access control or Apache Ranger, you can only edit a data product if you either have created it or have been granted Alter privileges.

Warning

Use extreme caution and courtesy when editing published data products. Data is often subject to SLAs and modifying it unnecessarily may adversely affect business goals.

Clone a data product#

You can clone a data product from the Overview pane Clone button available in the ellipsis menu. After cloning a data product, you can make edits to the data product such as changing the domain; or adding, editing, and deleting datasets. Bookmarks and ratings are not copied from the cloned data product.

Note

If your organization uses access control such as SEP’s built-in access control or Apache Ranger, you can only see the data products you are allowed to access. You can only create a data product if you have been granted Create privileges within the domain of interest.

  1. Click Clone.

  2. Rename the data product in the Data product name field.

  3. Click Catalog to select the catalog in which to store the schema.

  4. Click Domain to select the domain that the data product is assigned to. Only domains for which you have Create access to can be selected.

  5. Click Create clone.

Delete a data product#

You can delete a data product from the Overview pane using the Delete button available in the ellipsis menu.

Note

If your organization uses access control such as SEP’s built-in access control or Apache Ranger, you can only delete a data product if you have been granted Drop privileges.

Warning

Use extreme caution and courtesy when deleting published data products. Data is often subject to SLAs and deleting it unnecessarily may adversely affect business goals.