Ask Mode
Last updated
Was this helpful?
Last updated
Was this helpful?
Ask Mode provides a flexible, conversational interface for working with DinoAI. It's ideal for exploratory questions, reviewing documentation, and generating suggestions across multiple files.
Click the DinoAI icon (🪄) in the left panel.
Ensure "Ask Mode" is selected at the top of the panel.
Type your question or command in the prompt.
/model
Create new models with proper structure and logic
/explain
Understand existing models and their purpose
/fix
Identify and resolve errors in your models
/test
Create standard dbt™ tests for your models
/test_elementary
Create Elementary-specific model tests
/mermaid
Visualize model relationships
/sql_to_dbt
Convert existing SQL into dbt™ models
Ask Mode can assist with any dbt™ development inquiry. Common questions include:
"How can I optimize the performance of my dbt models?"
"What's the best way to handle data quality issues?"
"Can you suggest a pattern for implementing incremental models?
DinoAI generates dbt™ models based on your prompts, tailored to your project's structure.
How to Use
Open DinoAI: Click the DinoAI icon (🪄) in the left panel.
Access the "Create Model" Feature:
Select the "One Click" command: "Create a dbt model"
Or type /model
in the prompt.
Describe Your Model
Implement the Model:
Copy the generated SQL and paste it into your dbt project.
DinoAI provides detailed explanations of any dbt™ model, including purpose, structure, and key components.
How to Use
Right-click a .sql
file and select "Explain Model" from the DinoAI dropdown.
Alternative: Open DinoAI and type:
Review the Explanation: DinoAI will summarize your model’s purpose and output.
DinoAI helps identify and fix errors in your dbt™ models, ensuring a reliable data pipeline.
How to Use
Right-click a .sql
file and select "Fix Model" from the DinoAI dropdown.
Alternative: Open DinoAI and type:
Review and Implement Fixes:
Copy the debugged code into your project.
Use Data Explorer to validate the fixes.
DinoAI can automatically generate dbt™ tests to maintain data integrity and consistency.
Generating TestsGenerating Elementary Tests
How to Use
Right-click a .sql
file and select "Generate Tests".
Alternative: Open DinoAI and type:
Implement the Test:
Copy the test code into your schema.yml
file.
Run dbt test
to validate.
How to Use:
Right-click a .sql
file and select "Generate Mermaid Diagram".
Alternative: Open DinoAI and type:
Implement the Diagram:
Copy the Mermaid code into a .mmd
file.
Upload it to Paradime Editor and click the 👀 eye icon to view it.
DinoAI can convert raw SQL queries into dbt™ models, saving development time.
How to Use:
Right-click a .sql
file with raw SQL and select "Convert SQL to dbt model".
Alternative: Open DinoAI and type:
Implement the Model:
Copy the generated dbt model SQL and modify as needed.
Ask Mode is ideal for:
Exploratory Analysis: When you're investigating data patterns or trying to understand relationships
Learning dbt™ Concepts: When you need explanations about dbt™ features or best practices
Cross-File Suggestions: When you need recommendations that span multiple files
Quick Reference: When you need to understand existing models without modifying them
Modify as needed and validate using .
DinoAI can create entity relationship diagrams (ERDs) using , helping you visualize model dependencies.
– AI-generated commit messages & version control workflows.
– AI-powered data catalog and model documentation.
– Intelligent run analysis and troubleshooting in Bolt.