Can I use this for custom business logic testing?

Absolutely. The skill helps draft custom SQL tests located in the tests/ directory that identify failing rows based on specific business rules.

What types of dbt tests can this skill generate?

The skill generates schema tests (unique, not_null, etc.), dbt_utils tests, custom SQL data tests, and source freshness checks.

Is this compatible with all dbt-supported databases?

Yes, it follows standard dbt syntax which is compatible with Snowflake, BigQuery, Redshift, Databricks, and other supported adapters.

Does it support the dbt_utils package?

Yes, it provides implementation patterns for advanced dbt_utils tests such as accepted_range, recency, and cardinality_equality.

How does it assist with data freshness?

It generates YAML configurations for sources that include warn_after and error_after thresholds based on your specific latency requirements.

dbt Test Generator

Name: dbt Test Generator
Author: armanzeroeight

byarmanzeroeight

•

数据库管理

Generates comprehensive dbt test suites including schema validations, data quality checks, and source freshness monitors.

The dbt Test Generator skill streamlines the creation of robust data validation frameworks for analytics engineering projects. It automates the generation of essential schema tests, integrates advanced validation logic via dbt_utils, and establishes source freshness checks to ensure data reliability. By providing standardized implementation patterns for both YAML-based configurations and custom SQL tests, this skill helps data engineers maintain high quality standards, enforce referential integrity, and catch data anomalies before they impact downstream reporting.

主要功能

01Configures automated source freshness checks and warning thresholds

02Implements advanced dbt_utils tests for range, recency, and cardinality

03Creates custom SQL-based tests for complex business logic validation

04Generates core schema tests like unique, not_null, and relationships

0519 GitHub stars

06Provides optimized CLI commands for targeted test execution

使用场景

01Automating data quality validation for new staging and mart models

02Enforcing referential integrity across complex data warehouse schemas

03Setting up monitoring for stale data in upstream source systems

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add armanzeroeight/fastagent-plugins test-generator

For use in Claude.ai and ChatGPT

Download Skill