dbt-starrocks-production-readiness

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.