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:

Slash command	Example	Description
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

1. Click the Dino AI icon (🪄) icon on the left side of the Editor.

2. Select a "One Click" command

3. 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

1. Begin by typing code in any .sql file in the Editor.

2. Type "/dino/" to trigger autocomplete suggestions.

3. Press "Tab" to accept, or "Esc" to cancel.

4. 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

1. Make changes to your code.

2. Click on "Write Commit" in the Git Lite panel.

3. Review the AI-generated commit message. If unsatisfied, click "Write Commit" again for a new suggestion.

4. 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

1. Click "Catalog" tab located in the Apps Panel within the Code IDE.

2. Click "Autogenerate" at the top left of the Catalog panel

3. Edit, regenerate model description as needed.

4. Save changes.

Tutorial