What Can brewdata Do for Your dbt Projects?

• 🏗️ Generate dbt Models - Create dimensional models, fact tables, and staging models from natural language with project context
• 🔧 Build dbt Macros - Generate reusable macros for data transformations and business logic
• 📋 Create Schema Files - Automatically generate schema.yml with comprehensive documentation
• 🔍 Debug dbt Issues - Troubleshoot compilation errors, test failures, and performance problems using project knowledge
• 📊 Optimize SQL - Improve query performance and follow dbt best practices based on your existing patterns
• 🧪 Write dbt Tests - Generate generic and singular tests for data quality assurance
• 📝 Document Your Project - Create comprehensive project documentation and README files
• 🎯 Context-Aware Responses - Get AI assistance that understands your project structure, naming conventions, and existing code patterns

Quick Start for dbt Projects

1. Install brewdata VS Code extension
2. Open your dbt project in VS Code
3. Project Indexing - brewdata will automatically scan and index your project files for better context
4. Try Your First dbt Task - Generate a staging model or create documentation

Example dbt Tasks to Try:

• "Create a staging model for the users table following our project's naming conventions"
• "Generate a schema.yml file for my models/staging directory based on existing patterns"
• "Build a macro to calculate customer lifetime value similar to our existing metrics macros"
• "Help me debug this dbt compilation error using context from my project"

Key Features for dbt Development

Intelligent Codebase Indexing

The game-changing feature that makes every conversation context-rich:

• Automatic Project Scanning - Indexes all dbt models, macros, tests, and documentation files with one single click.
• Pattern Recognition - Understands your project's naming conventions, folder structures, and coding patterns
• Context-Aware Responses - Every AI interaction leverages your existing codebase for relevant, project-specific suggestions
• Real-time Updates - Continuously updates the index as you modify files to maintain current context
• Cross-Reference Intelligence - Understands relationships between models, sources, and dependencies
• Custom Convention Learning - Adapts to your team's specific dbt practices and standards

Specialized dbt Modes

brewdata provides four specialized modes tailored for dbt analytics engineering, all enhanced with codebase indexing:

• Generate Mode: Create dbt models, macros, tests, and documentation from natural language descriptions using project context
• Plan Mode: Design dbt project architecture, model dependencies, and transformation strategies based on existing patterns
• Ask Mode: Get answers about dbt best practices, troubleshooting, and project-specific questions with full project awareness
• Debug Mode: Systematically diagnose dbt compilation errors, test failures, and performance issues using indexed project knowledge

dbt-Specific Intelligence

brewdata understands dbt concepts and provides intelligent assistance for:

• Model Materialization Strategies - Choose between table, view, incremental, and ephemeral based on your use case and existing patterns
• dbt Jinja Templating - Generate complex Jinja logic for dynamic SQL and configuration following your project's style
• Testing Strategies - Create comprehensive data quality tests including custom generic tests that follow your project's testing patterns
• Performance Optimization - Analyze and improve model performance with proper indexing and partitioning based on your data warehouse
• Documentation Generation - Auto-generate rich documentation with field descriptions and business context consistent with your existing docs

Common dbt Use Cases Enhanced with Context

🏗️ Model Development

• Staging Models: Transform raw source data with type casting and basic cleaning following your project's staging patterns
• Intermediate Models: Build reusable business logic components consistent with existing intermediate layer design
• Mart Models: Create final dimensional models and fact tables for analytics using established naming and structure conventions
• Snapshot Models: Track slowly changing dimensions over time following your project's snapshot strategies

📊 Data Quality & Testing

• Generic Tests: Validate uniqueness, not null, relationships, and accepted values using patterns from existing tests

• Singular Tests: Create custom SQL-based tests for complex business rules following your project's testing conventions

• Model Contracts: Define and enforce data contracts between models based on your project's contract patterns

📚 Documentation

• Schema Documentation: Comprehensive field-level descriptions and metadata following your documentation standards
• Model Documentation: Business context, assumptions, and usage guidelines consistent with existing model docs
• Data Lineage: Visual representation of data flow through your project leveraging indexed model relationships

Documentation & Resources

Disclaimer

Please note that brewdata, Inc does not make any representations or warranties regarding any code, models, or other tools provided or made available in connection with brewdata, any associated third-party tools, or any resulting outputs. You assume all risks associated with the use of any such tools or outputs; such tools are provided on an "AS IS" and "AS AVAILABLE" basis. Such risks may include, without limitation, intellectual property infringement, cyber vulnerabilities or attacks, bias, inaccuracies, errors, defects, viruses, downtime, property loss or damage, and/or personal injury. You are solely responsible for your use of any such tools or outputs (including, without limitation, the legality, appropriateness, and results thereof).

Enjoy brewdata! Whether you keep it on a short leash or let it roam autonomously, we can’t wait to see what you build.