Creating Datasets

Before you can visualize and explore data, you must create a dataset. Nitro Explorer is pre-loaded with several datasets but you can also create your own.

Users can create Private or Shared datasets:

  • Shared datasets - Created on shared databases and accessible to other users within the organization. For example, production_v is shared database, therefore all datasets created on production_v are shared datasets.
  • Private datasets - Created on user-specific databases. Cannot be accessed by anyone other than the creator. For example, production_v::modifyall<username>__v is a user-specific database, therefore all datasets created on it are private datasets.

To switch the dataset from private to shared mode or vice-versa:

  1. Select Edit dataset from the More Actions menu on the dataset you want to switch the database.

  2. Select the appropriate user-specific or common database, depending on whether you want a private or shared dataset, from the Database drop-down menu.

  3. Select Save.

If your visualization can be based on the data in Nitro without any manipulation or joining of other data, you can create a physical dataset to power the chart. If you need a more complex or derived dataset to power your chart, you must create a virtual dataset.

Creating a Physical Dataset

To create a physical dataset:

  1. Select Datasets from the Data menu on the Nitro Explorer home page.

  2. Select the +Dataset button.

  3. Select the Datasource, Schema, and Table for the new dataset.

  4. Select Add.

To upload a CSV as a dataset:

  1. Select Upload a CSV from the Data menu on the Nitro Explorer home page.

  2. Complete the required fields on the CSV to Database configuration form.

    Users can upload a parquet file as a CSV by specifying the columns in the Use Columns section of the CSV to Database configuration upload form.

  3. Select Save.

To upload an Excel sheet as a dataset:

  1. Select Upload Excel from the Data menu on the Nitro Explorer home page.

  2. Complete the required fields on the Excel to Database configuration form.

  3. Select Save.

Creating a Virtual Dataset

To create a virtual dataset:

  1. Select SQL Editor from the SQL Lab menu on the Nitro Explorer home page.

  2. Create an SQL query.

  3. Select Run.

  4. Select the Results tab.

  5. Select Explore.

  6. Save the query and results as a new virtual Dataset or create a new one.

  7. Specify the configuration you wish to use to visualize the data in the Chart Builder.

Related Topics