DataOps.live Assist — your AI-Powered Copilot

PubPrev

DataOps copilot for the data product platform

DataOps.live Assist is a chat-based AI-powered copilot that improves your user experience on the data product platform. It enhances the workflow for every team member, regardless of their role. Use Assist to massively increase each team member's productivity and do more with the same.

• As a data engineer, use it during your development cycle.
• As a data product owner, use it during review and release management sessions.
• As a support engineer, use it during incident resolution as guided action.

Assist for data engineers

DataOps.live Assist supports data engineers during the development of MATE dbt models. The main use cases are:

• Suggest models from natural language inputs
• Describe SQL or Python that is missing documentation
• Explain 1000+ lines of complex SQL

Overall, you can enjoy three times better productivity.

Assist for data product owners

DataOps.live Assist automatically summarizes and describes complex change requests, helping data product owners quickly understand and approve merge requests. This speeds up the process, meeting business needs faster and reducing time to production by 50%.

Assist for support engineers

DataOps.live Assist analyzes data pipeline failures, identifies the root cause, and provides natural language steps to resolve the incident.

With less back-and-forth communication in your team and with Dataops.live Support, experience a 10X faster resolution time for incidents.

Developing your SQL models

Dataops.live Assist provides data engineers with integrated tools to help in the creation of MATE models. You can access these tools through the DataOps development environment DevReady.

Open any of your DataOps projects in Develop in VS Code, accept the disclaimer, and then proceed to start Assist from either:

• The file explorer: Under dataops right-click a model and select Send to Assist.

• The individual SQL or YAML file you are working on: Use the icons on the top right to initiate a few options with Assist.

With Assist, you can combine artificial intelligence and human intuition and get answers to any of your questions through the prompts and:

• Create new models
• Document YAML or SQL models
• Explain SQL

Opting in and out of Assist on DevReady

To access Assist on DevReady, you don't need to take any action, as the feature is automatically enabled for all users. Simply accept the disclaimer when prompted to start using Assist.

note

Clicking Cancel will simply close the disclaimer window. It will not opt you out of Assist.

While Dataops.live Assist is beneficial for most users, but your preference may still vary. If you want to opt out of Assist, email us at Support team for assistance.

It's important to note that opting out of Assist will be global — you'll lose access to all its features. This includes the automatic generation of MR summaries.

Creating new models

Assist suggests MATE models from your natural language inputs.

Based on your prompt, you will have an initial <model>.sql created in seconds. In addition, Assist generates the corresponding <model>.yml containing the model documentation for you.

1. Right-click a SQL model and select Create a new model with Assist.

   The new model will be created in the same folder as the model you clicked on.

2. Enter your query description in the top field of VS Code and press Enter on your keyboard.

   

   Assist generates a preview of the new model. You can ask Assist in the prompt to save the new model in a specific path.

3. Click Create below the preview to generate the .sql file.

   

   You can keep chatting with Assist to refine the model according to your needs.

4. Use the proposed prompts or ask Assist directly to document the new model and click Create to generate the YAML file.

5. On the top right of VS Code, click the Execute dbt SQL icon to run the SQL query and check the output data in the console.

Documenting models

Assist describes your SQL or YAML model that is missing documentation.

Given a SQL model, Assist generates a <model>.yml, which is fully documented with model and column descriptions.

Given a YAML file with missing descriptions or column information, Assist uses the matching <model>.sql file to document the descriptions in the <model>.yml file.

You can review and choose which changes to commit to Git.

1. Open the SQL model or YAML file without a description.

   

2. Click the pencil icon on the top right of VS Code.

   Assist starts generating a preview with a version of the SQL model or YAML file with a description.

3. If satisfied, click Create below the preview to generate the model or file with a description.

Explaining models

Assist explains your SQL model and generates a summary to help you start your development work.

This is helpful for long and complicated SQL queries, as it can be challenging to understand 1,000+ lines of code.

1. Open the SQL model for which you need an explanation.

   

2. Click the bulb icon on the top right of VS Code.

   A summary and explanation are generated for the open model.

Speeding up merge request review and approval

Once a merge request is created, Dataops.live Assist automatically generates an insightful MR summary. It makes reviewing easier by giving a short and informative summary of the changes in an MR.

All private preview users have assist enabled by default, enhancing their experience with seamless MR summaries. When you create an MR, you'll see a new activity in the MR overview with this message:

Assist thoroughly analyzes the MR changes. After reviewing, It records a message under Activity. The message includes a summary and detailed explanation of the changes.