What problem does it solve?
This Skill helps you make a dbt project targeting StarRocks safe and reliable in production by covering CI state, permissions, secrets, run/test behavior, and operational practices that prevent silent regressions and breaking changes.
Core Features & Use Cases
- Slim CI with state:modified+: Builds and tests only changed models and their downstream dependents to reduce costs and feedback time.
- Production RBAC for dbt and post-hooks: Grants only the minimal StarRocks privileges dbt needs to run, analyze, and access required catalogs/schemas.
- Secrets management and profiles.yml safety: Uses environment variables (and optional Vault generation) to avoid hardcoded credentials.
- Breaking change detection: Compares production vs dev relations/columns to fail fast when schema changes would break downstream consumers.
- Production deployment options and scheduling: Supports running via Airflow or dbt Cloud patterns and includes doc generation/hosting.
- Operational guardrails: Handles dbt exit codes in CI, ensures manifest.json is uploaded after prod runs, and encourages selective model execution.
Quick Start
Configure your StarRocks RBAC for a dedicated dbt user, store dbt profile credentials via environment variables or Vault, then run CI using state:modified+ against a previously stored production manifest to detect breaking changes before merge.
