Dbt Test Creator

What it does

This skill automatically generates dbt (data build tool) tests based on your data model definitions. It analyzes the structure of your models and creates corresponding test configurations to ensure data quality and consistency within your data warehouse. The generated tests cover aspects like uniqueness, not null constraints, and relationships between tables.

When to use it

• New dbt projects: Quickly establish a baseline for testing when setting up a new dbt project.
• Expanding existing models: Automate test creation as you add or modify data models in your existing dbt workflow.
• Ensuring data quality: Proactively identify and prevent data errors by automatically enforcing constraints through generated tests.
• Reducing manual effort: Eliminate the repetitive task of manually writing dbt tests for each model.

Key capabilities

• Generates dbt test configurations.
• Analyzes data model structures.
• Creates tests for uniqueness, not null constraints, and relationships.
• Automates test creation process.

Example prompts

• "Create dbt tests for my 'customers' model."
• "Generate tests based on the schema of my 'orders' table in dbt."
• "Can you create a uniqueness test for the 'customer_id' column in my 'transactions' model?"

Tips & gotchas

• Requires access to your dbt project and data models.
• The generated tests may need adjustments based on specific business logic or edge cases not captured by the schema alone.