skills.rest
yuezhen-huang
yuezhen-huangCOMMUNITY
Explore all skills by this author →
GitHub

aeolus

Query Aeolus BI dashboards, datasets, and ad-hoc SQL across cn, sg, and va regions.

Updated Apr 30, 2026
Search Tags:#data analytics#bi dashboard#dataset#clickhouse#sql query#aeolus#query editor
One-click install
npx skills add https://github.com/yuezhen-huang/my-bytedance-skillhub --skill aeolus-yuezhen-huang
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: aeolus
Source: https://github.com/yuezhen-huang/my-bytedance-skillhub/tree/main/aeolus
Command: npx skills add https://github.com/yuezhen-huang/my-bytedance-skillhub --skill aeolus-yuezhen-huang

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Aeolus BI data is spread across dashboards, datasets, and the Query Editor, each with different APIs and authentication. This Skill routes your request to the correct capability group so you can inspect dashboards, run dataset-bound SQL, or execute ad-hoc queries without guessing which interface to use. ## Core Features & Use Cases - Dashboard Chart Queries: List charts and filters on a dashboard, fetch candidate filter values, and pull data for a specific chart with filter overrides and dry-run previews. - Dataset & SQL Queries: Discover apps and datasets, inspect dimensions/metrics and partition fields, and run SQL against a single known dataset with OAuth credentials. - Query Editor Ad-hoc SQL: Run exploratory or multi-table SQL without a dataset context, manage QE folders/files, and poll long-running task status and logs. - Use Case: A user pastes an Aeolus dashboard URL and asks for last week's data on one chart. The Skill lists the charts, applies a relative date filter via dry-run validation, then returns the chart's rows with effective filters confirmed. ## Quick Start Ask the assistant to list the charts on your Aeolus dashboard URL, or to run a SQL statement, and it will pick the right capability group after clarifying your intent.

Frequently Asked Questions about aeolus

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query data from an Aeolus dashboard chart?▼

Use the query_report action with the dashboard URL and a report_id or report_name. Call get_dashboard first to list available charts and filters, then optionally override filters such as date ranges or multi-select values.

What is the difference between query and qe_query in Aeolus?▼

query runs SQL against one specific known dataset_id using OAuth credentials, while qe_query runs arbitrary ad-hoc or multi-table SQL through Query Editor with Titan Passport auth. Default to qe_query when no dataset_id is given or the SQL joins tables.

How do I run ad-hoc SQL on Aeolus without a dataset?▼

Use the qe_query action with just your SQL string and an optional region. It creates a temporary Query Editor file, executes the SQL, and polls until completion, returning rows or a task_id for later status checks.

Does Aeolus dataset query support multiple regions?▼

Yes, dataset actions require an explicit region parameter of cn, sg, or va, each needing its own OAuth credentials configured via gdpa-cli aeolus credential set. Dashboard and Query Editor actions default to cn but also support sg, va, and usttp.

Why does my Aeolus chart query fail with missing columns errors?▼

Errors like aeolus/clickhouse/unknownIdentiferExplict with missing columns indicate dataset schema drift on the server side, which also breaks the browser UI. This is not fixable from the client; report the failing chart and missing columns to the dataset or dashboard owner.

How do I verify filter overrides before running an Aeolus chart query?▼

Set dry_run to true on query_report to preview the exact request body without sending the query. The response shows effective_filters, unmatched_filters for typos, and the full request_preview so you can fix issues before running the real query.

Related Skills

Explore More Data & Analytics Skills→
mkgs-databricks-demosmkgs-databricks-demos
1

databricks-aibi-dashboards

Design and deploy Databricks AI/BI dashboards with validated SQL queries.

Official
Advanced
webn77webn77

data-insight

Analyze SQL and BigQuery data to identify trends, anomalies, and opportunities.

Community
Intermediate
StarRocksStarRocks
73

data-lake

Diagnose StarRocks external catalog query failures and stale data.

Official
Advanced
mirzadhammirzadham

clickhouse-io

Implements ClickHouse table schemas, query optimization, and data ingestion patterns for analytical workloads.

Community
Intermediate