TD Hive SQL with TD-specific functions and Hive-only features (lateral view, explode, MAPJOIN hint). Use when Trino memory errors occur or for Hive-specific syntax.
Advanced tdinterval patterns including offset dates (-1d/2025-10-01, -7d/-1d, 0M/now), tdintervalrange for debugging, tdtimestring for display formatting, and partition pruning optimization.
TD Trino performance optimization including CTAS (5x faster), UDP bucketing for ID lookups, magic comments for join distribution, REGEXPLIKE vs LIKE, and approx functions.
TD Trino SQL with TD-specific functions (tdinterval, tdtimerange, tdtimestring, tdsessionize). Use for time-based filtering, partition pruning, and TD query patterns.
YAML format reference for action reports rendered via previewactionreport. MUST be read before writing any action report YAML — defines the report structure (title, summary, actions array) and action item fields (asis, tobe, reason, priority, category, impact) with incremental build workflow. Required by seo-analysis…
Build agentic workflow pipelines using Graflow (Python). Use when the user asks to create, edit, or debug a Graflow workflow, agentic pipeline, or automated multi-step business process. Covers @task decorator, workflow composition (>> sequential, | parallel), Studio Agent integration with the ephemeral-per-task…
YAML format reference for grid dashboards rendered via previewgriddashboard. MUST be read before writing any dashboard YAML — defines the page structure, 6 cell types (kpi, gauge, scores, table, chart, markdown), grid layout rules, cell merging syntax, and incremental build workflow. Required by seo-analysis and any…
Build interactive React dashboards in Treasure Studio using renderreact. Use when the user explicitly asks for an interactive dashboard or custom React component beyond what renderchart supports.
Use when the user wants to review, validate, or check a scheduled task before enabling it. Runs two parallel sub-agent checks — structural validation and quality assessment. Triggers on "review this task", "check my scheduled task", "validate task", "is this task ready", etc.
Use when the user wants to create, set up, or configure a scheduled task in Treasure Studio. Covers TASK.md authoring, schedule.yaml configuration, script creation, and direct file-based task setup. Triggers on "create a scheduled task", "set up a recurring job", "automate daily report", "schedule a task", "cron job"…