dbt_project.yml with sensible materializations, schema naming, and tags. In this guide you update your project configuration to match your folder structure.
Prerequisites
- DinoAI copilot access in your Paradime workspace.
- A dbt™ project with a
dbt_project.ymlfile and an organized folder structure.
Steps
1
Add your dbt_project.yml as context
In DinoAI, click the ”@” symbol and add your existing
dbt_project.yml so DinoAI preserves your custom settings while adding new configuration.2
Enter your prompt
Describe the configuration you want. For example:
Can you update my dbt_project.yml to map all my models to my folder structure so each SQL file writes to the respective schema, and make sure they are tagged?DinoAI analyzes your folder structure and existing configuration, identifies model types based on folder organization (staging, intermediate, marts, and so on), and generates configuration sections with schema naming and materializations. If configured, it applies your .dinorules preferences.
3
Review the generated configuration
Review the proposed changes before accepting them. The output maps each folder to a materialization, schema, and set of tags.
4
Accept and build
Accept the changes, then run a build to confirm models write to the expected schemas with the right materializations.
Your
dbt_project.yml maps each folder to the correct materialization, schema, and tags, and a build writes models to the expected schemas. If a model lands in the wrong schema, check that its folder matches a configured section.Next steps
Generate documentation
Add model and column descriptions with tests.
Build marts models
Combine multiple models with business logic.
DinoAI use cases
Explore more ways to work with DinoAI.
Copilot reference
How context and Agent Mode work.