Guide StarRocks table design, partitioning, and materialized view management.
npx skills add https://github.com/nq-rdl/agent-extensions --skill starrocks
Please help me install this Agent Skill. Skill: starrocks Source: https://github.com/nq-rdl/agent-extensions/tree/main/skills/starrocks Command: npx skills add https://github.com/nq-rdl/agent-extensions --skill starrocks
StarRocks analytic workflows often suffer from poorly designed schemas, suboptimal partitioning, and lack of acceleration techniques. This guide helps data engineers and analysts design efficient tables, loading patterns, and query optimization strategies to achieve faster analytics at scale.
Design a StarRocks schema with a partitioned table and run a representative query to validate performance.
High-intent search queries and answers about installing and using this skill.
Choose StarRocks table types such as Duplicate Key, Aggregate, Unique Key, or Primary Key based on your query patterns, and apply partitioning strategies to optimize data scanning and analytics performance at scale.
Accelerate slow StarRocks BI dashboard queries by collecting CBO statistics, designing synchronous and asynchronous materialized views, applying colocate joins, and leveraging query caching mechanisms to speed up execution.
StarRocks materialized views precompute and store query results using synchronous and asynchronous refresh patterns to keep data fresh, reducing computation overhead and accelerating BI workloads.
Yes, you can query internal and external catalogs in StarRocks and leverage information_schema for metadata queries and governance, enabling seamless access to external data sources within your analytic workflows.
Recommended StarRocks loading patterns include streaming ingestion, broker loading, and upserts, often combined with materialized view-backed refresh approaches to maintain data freshness with minimal operational overhead.
Tnemo65Scale distributed data processing for ML workloads with streaming and batch pipelines.
ivanshamaevCreate and manage StarRocks materialized views with refresh and rewrite tuning.
ivanshamaevDiagnose and optimize StarRocks equi-join strategies using EXPLAIN output.
timequityOptimize data warehouse queries and storage across Snowflake, BigQuery, and Redshift.
