Skip to content
AIV

CDS Dataset

A Cache Dataset (CDS) stores pre-executed dataset results for faster dashboard performance. When you run a dataset and save the output, AIV creates a CDS file. Dashboards then read from this cache instead of querying the source each time, reducing load and improving response times.

Overview

A CDS file is generated by executing a dataset and saving the result. Once created, the system retrieves data from the cache rather than the original data source. This approach optimizes performance and keeps dashboards responsive, even with large datasets or complex queries.

Benefits

BenefitDescription
Easy Data SharingShare the CDS with others without requiring access to the original data source or shared resources.
Better PerformanceCDS files serve data faster because they bypass the original data source.
Cross-Platform CompatibilityData in a CDS file can be downloaded and used across different platforms.
Flexible CreationCreate a CDS from any dataset for flexible data management.

Steps to Create a CDS Dataset

Step 1: Select a Dataset

  1. In the DATASETS section, select the dataset you want to convert to CDS.
  2. Click the Schedule icon in the Options column for that dataset.

Schedule icon

Step 2: Configure the Schedule Dialog

The Schedule dialog provides four tabs:

TabPurpose
ParameterEnter parameters for the dataset (if applicable).
ScheduleSet the schedule frequency and type.
OutputSpecify the output name, format, suffix, path, and event options.
EmailMap emails to share the dataset with specific users.

Schedule options

Step 3: Configure Output and Run

  1. Open the Output tab.
  2. Enter the required Name for the CDS.
  3. Optionally configure Format (e.g., CDS), Suffix, and Path.
  4. Select Replace Default if you want to override default output settings.
  5. Click Run to execute.

Output configuration

:::tip Multiple Parameters To pass multiple parameters, use a query like WHERE IN ({{country_para}}). For a single parameter, use the Parameter tab as shown above. :::

Step 4: Monitor the Schedule

  1. Go to Requests > Requests.
  2. Click the Completed tab to view the status of the CDS execution.

Completed requests

Step 5: Verify the CDS Dataset

  1. Return to the DATASETS section.
  2. Locate the new CDS file (Type: cds) in the list.
  3. Double-click the CDS to open it and view the cached data in the Edit Dataset dialog.

CDS preview

Explore other ways to create and manage datasets in AIV:

Data SourceGuide
Drag & dropCreate Dataset
ExcelDataset using Excel
CSVDataset using CSV
JSONDataset using JSON
ParquetDataset using Parquet
NoSQLDataset using NoSQL
Flat filesDataset using Flat files
Google BigQueryDataset using Google BigQuery
Google SheetDataset using Google Sheet
External sourcesDataset using External sources
Stored ProcedureDataset using Stored Procedure
ViewDataset using View