dbt Integration

Project Location

• Root: dbt/ (in workspace root, NOT in code/)
• Models: dbt/models/ organized by layer (staging, intermediate, mart, analytics)
• Config: dbt/dbt_project.yml
• Profiles: dbt/profiles.yml

Access Control

⚠️ CRITICAL: The dbt directory has restricted write access. When creating or modifying dbt models:

1. Create SQL in code/.builder/dbt-models/ first
2. Test the query using a script in code/scripts/
3. Validate results before requesting deployment
4. User must manually copy to dbt/models/ directory

Schema Organization