Prerequisites
- DinoAI copilot access in your Paradime workspace.
- A dbt™ project with a
sources.ymlfile or existing models to build from.
Steps
1
Open DinoAI in Agent Mode
Click the DinoAI icon in the right panel, then select Agent Mode if it is not already selected.
2
Add context (optional)
Add context by clicking the ”@” symbol and selecting:
- Existing similar models to follow their pattern.
- The models you want to reference.
- Directory structure to understand project organization.
3
Enter your prompt
Describe the model you want to create. For example:DinoAI analyzes your
Create an intermediate model that joins customer data from the ‘stg_customers’ model with order information from ‘stg_orders’, and calculate lifetime value metrics.
Be specific about:
- The type of model (base, intermediate, mart).
- Tables to join or reference.
- Any calculations or transformations needed.
- Materialization type if relevant.
sources.yml file and any provided context, creates the appropriate folder structure, and generates a model with properly structured CTEs and join conditions. If configured, it applies your .dinorules preferences.4
Review and accept the changes
Review the generated SQL, then accept the changes to create the file in your project.
5
Test the model
Run the model using dbt™ commands or the Data Explorer to confirm it produces the expected output.
The model builds without errors and returns the columns and transformations you asked for. If the build fails, check that the referenced models exist and that join keys match, then re-run the prompt with those models added as context.
Next steps
Build marts models
Join multiple models with business logic into marts.
Generate documentation
Add descriptions and tests to your new models.
DinoAI use cases
Explore more ways to work with DinoAI.
Copilot reference
How context and Agent Mode work.