Creating a dataset

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

You can create a dataset for use with Kyvos. When you create a dataset, choose the connection from which the data needs to be fetched. As you apply settings to sort and filter the columns, you can preview the results to make sure you get the results you are seeking.

The total number of columns is shown above the list of their names. If the column count has changed, for example, if any columns are hidden, the column total includes additional information and a link. For example, "Total 29 columns out of which 5 columns are hidden." When you click the link, the information dialog informs you that column details have been updated and lists the number of columns added and deleted, and recommends that you review the updated file. Click Dismiss to close the dialog.

Points to know: 

• You can mark a file as a Fact to use it as a fact table in relationships. And you can hide columns not required for analysis. 

• Use the Actions menu (...) to validate the dataset, share it, add a note, or show related entities.

• If your instance of Kyvos has been configured via the portal.properties file to support it, you can register a file with a Presto connection. You can format columns and preview the result.

• To register a file with a Presto connection, see Creating a file with a Presto connection. You can also create register files by  Writing SQL queries using data in Hive. 

• To learn more about the effects of some of the settings you can use while registering the file, see Logic for creating relationships and semantic model.

To create a file, perform the following steps. 

1. From the Toolbox, click Datasets.

2. Click the Actions menu (  ⋮ ) and click Add Dataset.

3. Select the Connection from the list.

4. Select any one of the following input types: 

   • HDFS

   • Table

   • SQL

See Formatting, sorting, filtering file data while registering datasets to learn additional ways to customize the data while you register datasets.

Related topics

• File parameters

• Creating a file with a Presto connection

• Writing SQL queries using data in Hive

• Refining data in datasets

• Also see the common actions to know more about validating, sharing, and adding notes.