Skip to main content

Preview

Preview lets you see a small number of rows from a given dataset either in the original order or randomly. You can preview the entire dataset, a portion (such as a random sample or a percentage) of the dataset, or rows that meet a given condition.

Format​

Preview uses a single format: Preview the dataset <dataset> <version> (randomly) (where <column> is <predicate>) (then select <limit> rows | with percentage <percentage>).

Parameters​

Preview uses the following parameters:

  • dataset (required). The dataset to preview.
  • version (optional). The specified version of the dataset to preview.
  • percentage (optional). Whether the preview should be drawn as a percentage of the dataset.
  • column (optional). The column whose values to use as part of the previewing criteria.
  • predicate (optional). The predicate used as part of the previewing criteria.
  • limit (optional). The desired preview size.

Output​

If the dataset is successfully previewed, a success message appears in the conversation history and the previewed dataset becomes [dataset]_Preview.

Examples​

To preview the dataset, enter Preview the dataset <dataset name>.

To preview the dataset randomly with a sample size of 40, enter Preview the dataset <dataset name> randomly then select 40 rows.

To preview 20% of your dataset, enter Preview the dataset <dataset name> with percentage 20.

To preview only the rows in the dataset where the values of the Age column are greater than 18, enter Preview the dataset <dataset name> where Age is greater than 18.

To preview only the rows in the dataset where the values of the Age column are greater than 55 with a sample size of 30, enter Preview the dataset <dataset name> where Age is greater than 55 then select 30 rows.