Dataset Query

The Dataset Query component is a versatile tool designed to query and retrieve data from existing datasets. It enables users to construct data queries by specifying metrics, dimensions, filters, and sorting criteria to generate customized data frames.

Prerequisites

A dataset must be selected in the skill configuration under Skill Properties before using this component.

Configuration Options

Metrics: Accept both variables and dataset values
Dimensions: Accept both variables and dataset values
Filters: Accept both variables and dataset values
Limit: Accepts variables (typically numbers from 1-20)
- Example Variable Description: this is a single numerical value representing the number of rows of data the user would like to analyze
Sorting: Accepts dataset values, node values, or variables
- Example Variable Description: represents how the user would like the analysis to be sorted. use a format like {"col" : "column_name", "dir" : "asc or desc"}

Output

Generates a data frame that can be:
- Previewed using the eye icon in the output section
- Viewed in detail in the preview tab after skill execution
- Customized using custom code in the customize tab

Common Applications

1. Basic Performance Monitoring

Configuration:
- Metrics: daily_active_users, session_count
- Dimensions: date
- Limit: 7
- Sorting: date DESC

Purpose: Retrieve last week's daily user activity metrics

2. Regional Sales Analysis

Configuration:
- Metrics: total_revenue, order_count
- Dimensions: region, product_category
- Filters: date_range = last_quarter
- Sorting: total_revenue DESC
- Limit: 10

Purpose: Identify top-performing regions and product categories

3. Customer Segmentation

Configuration:
- Metrics: customer_lifetime_value, purchase_frequency
- Dimensions: customer_segment, age_group
- Filters: active_status = true
- Sorting: customer_lifetime_value DESC

Purpose: Analyze customer behavior patterns across different segments

Best Practices

Start with essential fields (metrics and dimensions) before adding optional configurations
Use the preview feature to verify query results before connecting to other components
Consider implementing custom code for complex data transformations
Test different combinations of metrics and dimensions to ensure optimal data retrieval

Integration

The Dataset Query component's output can be connected to various other components within the skill, making it a foundational element for data processing workflows.

Troubleshooting

Ensure the selected dataset is properly configured in Skill Properties
Verify that all variables used in the query are properly defined
Check the preview tab for immediate feedback on query results
Review custom code in the customize tab if unexpected results occur