DinoAI
DinoAI, developed by Paradime, is an AI-powered suite of features designed to enhance analytics engineering productivity streamline SQL and dbt™. DinoAI features include:
Copilot: A chat GPT 4.0-powered assistant in your editor, capable of creating models, fixing and debugging, generating tests, and addressing general inquiries.
Autocomplete: Enhance your coding speed with intelligent autocomplete suggestions that align with your project’s structure.
Commit Messages: Automatically craft precise, detailed commit messages, facilitating better communication within teams.
Data Catalog - Autogenerate: Automatically generates detailed, context-specific descriptions for your models and individual columns.
Discover detailed instructions on how to utilize each DinoAI feature, along with step-by-step video tutorials, below.
Copilot
Copilot is a ChatGPT-like interface within the editor that offers real-time coding assistance. It understands the intricacies of your dbt™ project, providing precise, project-specific guidance and solutions.
Slash Commands
In addition to entering inquiries into the prompt, you can leverage copilot's slash commands:
Generate tests for a dbt mode
📺 Tutorial
/test @model_name (e.g., /test @stg_orders)
Generates a test tailored to your dbt™ project's structure and content
Explain a dbt model 📺 Tutorial
/explain @model_name (e.g., /explain @stg_customers)
Provides a detailed summary of a dbt™ model's purpose, output, and key executions.
Find issues and fix a dbt model 📺 Tutorial
/fix @model_name (e.g., /fix @stg_orders)
Identifies and corrects errors in your dbt™ model.
Create a dbt model
📺 Tutorial
/model model_name additional_instructions (e.g., /model customer_order create model...)
Generates a new dbt™ model for your project.
How to Use
Click the Dino AI icon (🪄) icon on the left side of the Editor.
Select a "One Click" command
Enter your inquiry in the prompt and either press "Enter"
Tutorials - Slash Commands
You can also access DinoAI's slash commands via right clicking a .sql files:
Additionally, you can leverage the "ask dino;" command within your editor to create a dbt model!
Tutorial- "ask dino;"
Autocomplete
Autocomplete, powered by the “/dino/” command, provides smart autocompletion for SQL and dbt™ code, streamlining the creation of queries, columns, calculations, etc.
How to Use
Begin by typing code in any .sql file in the Editor.
Type "/dino/" to trigger autocomplete suggestions.
Press "Tab" to accept, or "Esc" to cancel.
The selected code will automatically fill into your model.
Tutorial
Commit Messages
DinoAI's Commit Messages feature automatically generates detailed commit messages tailored to your specific code changes, enhancing communication within your team.
How to Use
Make changes to your code.
Click on "Write Commit" in the Git Lite panel.
Review the AI-generated commit message. If unsatisfied, click "Write Commit" again for a new suggestion.
Commit and Push your changes
Commit Message feature is only available for Git Lite users.
Tutorial
Data Catalog - Autogenerate
Autogenerate, powered by DinoAI, automatically generates detailed, context specific descriptions for your data documentation. These descriptions are tailored specifically to your model and individual columns.
How to Use
Click "Catalog" tab located in the Apps Panel within the Code IDE.
Click "Autogenerate" at the top left of the Catalog panel
Edit, regenerate model description as needed.
Save changes.
Tutorial
Last updated