PriPrev DataOps copilot for the data product platform
DataOps.live Assist is an 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 it 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
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
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
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 aid in the creation of MATE models. You can access these tools through the DevReady command palette within the DataOps development environment.
Opt into DataOps.live Assist on DevReady
To access Assist on DevReady, do the following:
DATAOPS_FEATURE_ASSIST = trueas an environment variable in GitPod:
- In DevReady, go to Gitpod → User Settings → Variables (https://develop.dataops.live/user/variables).
DATAOPS_FEATURE_ASSIST = truefor your development workspace.
Using scope */** makes the environment variable available to all user workspaces.
gp env DATAOPS_FEATURE_ASSIST=truein the DevReady terminal. Note this will make the variable available only to the project you are currently working on. For example the scope will be automatically set to for example
Restart your workspace and you will have access to DataOps.live Assist.
Create new models
Create a new Model suggests MATE dbt models from your natural language inputs.
Based on your prompt, you will have an initial
<model>.sql created in seconds. In addition, the corresponding
<model>.yml containing the model documentation will be generated for you.
Create a new Modelfrom the command palette in DevReady.
- Enter your query description and set a path for the model you want to generate.
- Select the sources corresponding to your query and click Create to generate the SQL model and its YAML automatically.
- Run your query and check the results in the console.
Document this model describes your SQL or YAML model that is missing documentation.
Given a SQL model, the tool generates a
<model>.yml which is fully documented with model and column descriptions.
Given a YAML file that is missing descriptions or column information, the tool uses the matching
<model>.sql file to document the descriptions in the
You can review and choose which changes to commit to Git.
- Open the SQL model or YAML file without a description.
Document this modelfrom the command palette in DevReady or by clicking the pencil icon in the top right of the editor pane.
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 difficult to understand 1,000+ lines of code.
- Open the SQL model you need an explanation for.
Explain this SQLfrom the command palette in DevReady or by clicking the icon in the top right of the editor pane.
A summary and explanation are generated for the open model.
You can provide feedback on Dataops.live Assist either through the pop-up that appears while using any of its tools or at any time from the left sidebar.
- Click the Dataops icon and go to Assist Feedback.
- Select the tool you wish to provide feedback for and share your insights.
- Click Submit.
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.
Opting Out from DataOps.live Assist
While Dataops.live Assist is beneficial for most users, your preference may still vary. If you want to opt out of Assist, email us at email@example.com for assistance.