Automate dbt CI/CD with validation, linting, and selective builds.
npx skills add https://github.com/nrakow/ae-skills-dev --skill dbt-ci-cd
Please help me install this Agent Skill. Skill: dbt-ci-cd Source: https://github.com/nrakow/ae-skills-dev/tree/main/skills/dbt-ci-cd Command: npx skills add https://github.com/nrakow/ae-skills-dev --skill dbt-ci-cd
dbt project deployments can be error-prone and slow without a repeatable CI/CD workflow. This skill automates validation, linting, and deployment of dbt changes across PRs and production, reducing risk and manual effort.
Clone this skill into your repository and enable the provided workflow templates to start validating and deploying dbt changes.
High-intent search queries and answers about installing and using this skill.
dbt CI checks for pull requests validate changes by running SQLFluff linting, dbt parsing, and targeted dbt builds on modified models. This automated validation prevents errors before merging changes into production.
State comparison in dbt continuous deployment uses prod manifests as a baseline to defer and selectively build only changed models. This ensures safe promotions to production by comparing PR artifacts against current prod state.
Yes, this dbt CI/CD automation supports GitHub Actions, GitLab CI, and dbt Cloud Slim CI. It provides cross-platform reusable workflow templates and configurations for quick adoption across different CI platforms.
Yes, a prod manifest baseline is required to run selective dbt builds. Environment credentials and context from data-stack-context and dbt-project-setup are also needed to tailor the workflows for safe state comparison.
Automating dbt deployments with CI/CD workflows reduces manual errors by validating changes, linting SQL with SQLFluff, and performing selective builds. This creates a repeatable, safe promotion process across PRs and production.
SQL linting in dbt is automated using SQLFluff within CI checks on pull requests. The workflow parses dbt models and runs lint validation to catch SQL issues before changes are promoted to production.
nrakowSequence six foundational skills to scaffold a complete dbt analytics project.
beauschwabExecute dbt CLI commands with selectors and safe defaults.
ivanshamaevGenerate GitHub Actions pipelines for dbt and Airflow CI/CD with quality gates.
shaprisBuild and modify dbt models with ref() and source() macros.
