Datasets
A Qrvey Dataset is a collection of structured data used to create dashboards and visualizations within the platform. There are two types of Datasets. Managed Datasets store data inside Qrvey’s data repository, a high-performance, scalable, serverless OpenSearch cluster. Alternatively, Live Connect Datasetsprovide data access directly from its source, enabling real-time queries without the need to load data.
Create a Dataset
Navigate to the Data Module and make sure you are in the Datasets tab.
Click Create New Dataset. A dropdown will appear. Choose to create a:
- New Managed Dataset
- New Live Connect Dataset
Configure as Desired.
All new datasets are given the default name of
{connection name} - {table/view name}
. At this point your Dataset is ready for use; however you can make changes as needed.
View Datasets
- Navigate to Data > Datasets to browse all Datasets within the application.
Each dataset will be displayed as a card, displaying the following details:- Name — The name assigned to the Dataset.
- Type — Notes if it a Managed or a Live Connect Dataset.
- Status —
active
(ready to create visualizations),draft
(dataset is still loading), orfailed
(dataset is not properly loaded). - Last Loaded — The date that the data was loaded.
- Data Sync — Notes if Data Sync is
On
orOff
. - Data Source — The Connection used by this Dataset.
- Records — Number of records within the dataset.
- Columns — Number of columns within the dataset.
Mark Dataset as Favorite
To mark a Dataset as a favorite, follow these steps.
- Navigate to Data > Datasets.
- Find the desired dataset card.
- Click the star in the upper-right corner.
Manage a Dataset
- Navigate to Data > Datasets.
- Click on the desired Dataset.
- Configure and Manage the Dataset as Desired. For more details, please see:
Rename a Dataset
- Navigate to the desired dataset card.
- Click on its name.
- Type to change it as desired.
Share and Un-Share Datasets
By default, datasets are only accessible in the application in which they are created.
- Navigate to Data > Datasets.
- Find the desired Dataset and click its three-dot menu. A dropdown will appear.
- Click either Share Data with my Organization or Unshare with my Organization. A modal will appear.
- Click to confirm your choice in the modal and you will return to Data > Datasets.
Note: If unshared, any existing datasets and/or dataset views created from this dataset will no longer be available to users building charts and metrics. Any existing charts and metrics that have a dependency on this dataset will no longer show any data.
Delete a Dataset
- Navigate to Data > Datasets.
- Find the desired Dataset and click its three-dot menu. A dropdown menu will appear.
- Click Delete. A modal will appear.
- Click Delete to confirm your choice in the modal and you will return to Data > Datasets.