Create Dataset from Looker

This article details how to create Dataset from Looker.

PREREQUISITES:

1. Create New Dataset

Access New > Dataset > Create New

Enter the basics:

  1. Measured: select the measurement interval that applies to the level of aggregation that you want in your result set.
  2. Visible: define if Dataset should be searchable.
  3. Name: input a descriptive phrase.
  4. Category: specify Category to place the Dataset.

Proceed to Data tab to define details.

2. Specify Details for Data Collection

  1. Data Source: select the Looker Data Source.
  2. Trigger: select the required Data Collection Trigger to collect data for the Dataset.
  3. Element: select a Looker object that should serve as a basis for Dataset.
  4. Visual/Command: list all the data you would like to fetch from Looker:
    • Use Visual editor. This will automatically validate the command.
    • OR build your query by following MIQL syntax under Command.
  5. [Validate]
    • If the statement is valid, the Validation Rows Preview section pops-up at the bottom of the screen. You can also open it by clicking Show validation rows under the Visual/Command box.
  6. [Enable & View] to proceed to Dataset Viewer.