DinoAI

DinoAI, developed by Paradime, is an AI-powered suite of features designed to enhance analytics engineering productivity streamline SQL and dbt™ development

Features at a Glance

🤖 Copilot: AI-powered assistant that helps write, debug, and test dbt™ models through natural language

⚡️ Autocomplete: Context-aware code completion that understands your project structure and patterns

💬 Commit Messages: Smart generation of detailed git commit messages based on your code changes

📚 Data Catalog: Automated documentation that explains your models and columns in plain English

---

Copilot

Copilot is your AI assistant within the editor, offering real-time coding help and project-specific guidance.

Available Commands

In addition to entering generic inquiries into the Copilot prompt, you can leverage copilot's one-click commands:

Command	Example	Description	Tutorial
/test	/test @stg_orders	Generates a test tailored to your dbt™ project's structure and content	🔗
/explain	/explain @stg_customers	Provides a detailed summary of a dbt™ model's purpose, output, and key executions.	🔗
/fix	/fix @stg_orders	Identifies and corrects errors in your dbt™ model.	🔗
/model	/model create a dbt model called stg_orders that... [additional instructions]	Generates a new dbt™ model for your project.	🔗
/mermaid	/mermaid @stg_orders	Creates entity relationship diagrams (ERDs) of your dbt model's dependencies.	🔗
/sql_to_dbt		Converts existing SQL queries into dbt™ models	🔗

How to Use

Access the Copilot commands via the following methods:

Method #1 - Left Panel

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

2. Select a command

3. Enter your inquiry in the prompt and either press "Enter"

Method #2 - Right-Click

1. Right Click a .sql file in your editor

2. Hover over "DinoAI co-pilot"

3. Select your desired command

---

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.

---

Commit Messages

DinoAI's Commit Messages feature automatically generates detailed commit messages tailored to your specific code changes, enhancing communication within your team.

Commit Message feature is only available for Git Lite users.

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

---

Data Catalog

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.