Cross-industry, Data platform
SQL and dbt copilot for analysts
Explain, optimise and repair dbt models and SQL inside the workbench. Analysts lose time on failing models and slow queries.
Updated
- dbt models
- Data source
- Run results
- Data source
- Query plans
- Data source
On this page
What does the sql and dbt copilot for analysts do?
Analysts lose time on failing models and slow queries. The Voir copilot in the Data Engineering workbench explains what a model does, suggests incremental materialization or pre-aggregation, and proposes fixes for errors such as engine mismatches.
How is the agent designed?
- Pattern: Embedded copilot with read access to the project.
- Data scope: The workspace dbt project and query history.
- Human approval: Changes are applied by the analyst and committed to Git.
- Platform components: Voir, Data Engineering, Atlas
How does it work on DataNature?
- Ground it in governed data. Certified Gold tables and semantic-layer cubes give the agent consistent numbers; DocuContext partitions give it documents with links to source; the knowledge graph gives it relationships between entities where the use case needs them.
- Scope the twin. The Voir twin's data scope, document partitions and SQL allowlist are enforced by the Agent Meta-Harness inside every tool call, and Atlas applies masks and row filters for the user it acts for.
- Route the model. The AI gateway sends requests to an approved model endpoint and logs tokens, cost and latency.
- Keep a human in the loop. The agent recommends; people approve actions that change systems.
- Trace and evaluate. Every turn is traced, and answer quality is evaluated against real questions before and after each change.
What data does it use?
- dbt models
- Run results
- Query plans
Why run it on a sovereign platform?
The data, prompts, retrieved passages, model inference and logs all stay inside your jurisdiction, so the agent can work on regulated data without sending it to a foreign service.
How do we get started?
Dlytica Consulting can scope and build it, NeuralShore engineers can join your team, and Dlytica Academy-trained talent is ready to support it. Book a demo with Dlytica to see it on your own data.
Platform components in this use case
Learn more about each DataNature product and module mentioned here.
Platform modules
See it on your own data.
Book a demoDemos and quotes are handled by Dlytica, the company behind DataNature.