skills.rest
ivanshamaev
ivanshamaevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

dbt-starrocks-testing

Implement dbt tests for StarRocks with freshness checks and partition-scoped SQL assertions.

14|1|Updated May 5, 2026
Search Tags:#data quality#dbt#starrocks#data testing#ci validation#source freshness#singular tests
One-click install
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill dbt-starrocks-testing
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-starrocks-testing
Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/group_skills/starrocks_group_skills/dbt_starrocks_testing
Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill dbt-starrocks-testing

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you prevent broken or stale data from reaching downstream analytics by making dbt tests that are tailored for StarRocks workloads.

Core Features & Use Cases

  • Generic dbt tests in schema.yml: Use standard tests like not_null, unique, accepted_values, and relationships, plus dbt-expectations assertions for numeric and typing checks.
  • Source freshness checks: Configure loaded_at_field-based freshness thresholds to detect upstream delays before running dependent models.
  • StarRocks-friendly singular tests: Write custom SQL assertions (e.g., null rate, volume anomalies, referential integrity, no future dates) and scope them to partitions for performance.
  • Production-grade debugging: Enable store_failures so you can inspect failed rows after a run.
  • Operational performance safeguards: Use pre-run ANALYZE to refresh stats and avoid slow/incorrect cost-based plans.

Quick Start

Tell your agent: "Generate dbt StarRocks tests for my models and sources, including freshness checks, partition-scoped singular SQL tests, and dbt-expectations integration, then output the schema.yml and tests/*.sql content ready to paste."

Frequently Asked Questions about dbt-starrocks-testing

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

FAQPage Schema
How do I implement dbt tests for StarRocks to catch data quality regressions?▼

You can implement dbt tests for StarRocks by defining generic tests in schema.yml, writing custom SQL singular assertions, and configuring source freshness thresholds to detect data quality regressions before downstream models run.

Can I use dbt source freshness checks to detect upstream data staleness in StarRocks?▼

Yes, you can configure loaded_at_field-based source freshness thresholds in dbt to detect upstream delays in StarRocks before running dependent models, preventing stale data from reaching downstream analytics.

How do I write partition-scoped singular tests for large StarRocks tables in dbt?▼

Write partition-scoped singular tests by creating custom SQL assertions that target specific partitions. This optimizes testing performance for large StarRocks tables by limiting the data scanned during volume anomaly or null rate checks.

Does dbt-expectations integration work with StarRocks for data testing?▼

Yes, dbt-expectations integration is supported for StarRocks data testing. You can use these assertions alongside standard not_null, unique, accepted_values, and relationships tests for comprehensive numeric and typing checks.

What is the best way to debug failed dbt tests on StarRocks data pipelines?▼

The best way to debug failed dbt tests on StarRocks is to enable store_failures. This stores failed rows in a table so you can inspect them after a run, alongside running ANALYZE to refresh stats and avoid incorrect cost-based plans.

How do I control severity to warn instead of error during dbt CI validation?▼

You control severity in dbt CI validation by configuring tests to warn or error. This allows CI-friendly dbt test selection patterns to surface data quality issues without immediately blocking the entire pipeline run.

Related Skills

Explore More Data & Analytics Skills→
dylpickledevdylpickledev
4

dbt-model-scaffolder

Generate dbt model SQL scaffolds and schema.yml files with tests.

Community
Advanced
shekerkammashekerkamma

canary

Monitor live production deploys for console errors, performance regressions, and page failures.

Community
Advanced
ivanshamaevivanshamaev
14

starrocks-self-healing

Restart transiently paused StarRocks Routine Load jobs and remediate ingestion health issues.

Community
Advanced
AltimateAIAltimateAI

migrating-sql-to-dbt

Convert SQL stored procedures, views, and raw SQL files into dbt models.

Official
Intermediate