Feature Drop: Easy-Access Context Menu

First published July 22, 2024

Feature Description

We’re excited to introduce new context menu options that simplify working with files directly from your code editor. With just a few clicks, you can now:

• Copy File Name
• Copy File Name as Ref
• Dino AI Co-pilot Features

Top 3 Benefits

1. Increased Workflow Efficiency: The one-click option to copy the file name reduces the time spent navigating and handling file names, letting you focus on coding.
2. Streamlined Documentation: The ability to copy the file name as a reference simplifies creating documentation and referencing files in your code, making the process smoother and faster.
3. Faster Development: By minimizing the need for manual file name handling, these features speed up the development of dbt™ models and other coding tasks, enhancing overall productivity.

Quick Tutorial

Copy File Name

Let’s start with copying the file name. Right-click on a file and select ‘Copy file name’ to get an exact match of your file name, which can be used in documentation or scripts.

Copy File Name as Ref

Next, let’s copy the file name as a reference. Select ‘Copy Filename as Ref’. This copies the ref syntax, perfect for quickly referencing models in your dbt project.

Example usage in ‘testing.sql’:

1-- Example of using the copied referenceselect * from {{ ref('your_model_name') }}

‍

DinoAI Copilot

Now, let’s explore the DinoAI. Click on ‘Launch DinoAI Copilot’ to access its features

‍Fix Model: DinoAI will automatically identify and correct issues in your code.

1-- Example of corrected code
2with source as (
3    select * from {{ source('sheets', 'ingested_raw_orders') }}
4),
5renamed as (
6    select
7        id as order_id,
8        user_id as customer_id,
9        order_date,
10        status
11    from source
12)
13select * from renamed where 1=1
14

Generate Test: DinoAI will create high-quality tests based on your model’s structure and content

1-- Example of a generated test in schema.yml
2version: 2
3models:
4  - name: your_model_name
5    tests:
6      - unique
7      - not_null
8

‍Explain Model: Get a quick summary of your model. DinoAI provides a concise explanation of the model’s purpose and key executions, ideal for debugging, documentation, and onboarding.

Integrating with Elementary Data

If you use Paradime’s Elementary integration for data observability, you can also have DinoAI “generate elementary tests” from the context menu.
‍

Watch Full Tutorial

For Who?

These features are designed for developers who seek to optimize their workflow and streamline file management tasks within their development environment.

Availability

These new features are available in the Code IDE tier, offering enhanced capabilities to improve your coding experience.‍

‍Want to learn more about how we are changing the analytics engineering game? Of course you do! Get in touch HERE.