top of page

From "Suggest" to "Do": The Agentic Data Engineering Shift

2 days ago
13 min read

Agentic AI is moving data engineering from tools that suggest fixes to systems that diagnose, act, and verify — governed from the first pipeline run.


A data engineer gets paged at 2 a.m. because a pipeline silently started dropping rows after an upstream schema change. The AI copilot on her screen is genuinely helpful — it drafts a plausible fix, explains the likely root cause, even writes the test. She still has to read it, trust it, copy it into the right file, run the test suite herself, watch the deploy, and confirm the backfill actually reconciled. The copilot did the hard thinking. She's still the one doing the work.


That gap — between an AI system that can tell you what to do and one that can actually do it — is the single most consequential line running through data engineering right now. 

Agentic data engineering is the shift from AI systems that suggest fixes, queries, or documentation for a human to review and execute, to AI systems that autonomously diagnose, implement, test, and redeploy changes to data pipelines within governed boundaries — closing the loop between recommendation and action. 


Most of what got labeled "AI for data teams" over the last three years lived entirely on the suggestion side of that line: better autocomplete, better chatbots, better dashboards that could answer a follow-up question. Useful, but bounded. The next phase of the field is about crossing it — building systems that don't just recommend the fix, but implement it, test it, and stand behind the result. That's the agentic data engineering shift, and it's why the next fifteen weeks of this series exist.


The suggestion layer did its job — and hit its ceiling


It's worth being precise about what the first wave of AI-for-data actually delivered, because it was real progress, not vaporware. Text-to-SQL assistants let analysts query without waiting on an engineer. BI copilots — Tableau's AI features, ThoughtSpot Spotter, Hex's Magic — turned "can someone pull this number" into a chat message with an answer in seconds. Code-completion tools cut the time to write a dbt model or an Airflow DAG from scratch.

But every one of these tools shares the same shape: a human asks, the system answers, and a human decides whether to act on the answer. The system has no standing responsibility for the outcome. If the SQL is wrong, the analyst finds out when the number looks off. If the suggested fix breaks something three tables downstream, nobody knows until a different pipeline fails next Tuesday. The AI produced an artifact — a query, a snippet, a chart — and handed it back across the fence.


That fence is exactly where the toil in data engineering has always piled up. Anthropic's own research on effective agent design draws a sharp distinction between a "workflow" — a predefined sequence where an LLM fills in one step — and an "agent," a system that dynamically directs its own process and tool use to accomplish a task and can adapt when the situation changes (Anthropic Engineering). Almost everything data teams adopted between 2023 and 2025 was the workflow pattern: a single well-scoped LLM call, wrapped in a nice interface. It looked like AI transformation. Functionally, it was better search and better autocomplete sitting on top of a stack whose actual maintenance burden — stale documentation, undocumented lineage, ingestion pipelines nobody's confident enough to touch — never moved.



What "agentic" actually changes?

Agentic systems close the loop the suggestion layer left open. Instead of producing one artifact and stopping, an agent perceives the state of a system, plans a sequence of actions toward a goal, uses tools to execute those actions, observes what happened, and adjusts — repeating that cycle until the goal is met or a boundary condition tells it to stop and ask a human. The distinction isn't about model size or which vendor's logo is on the tool. It's architectural: does the system take actions with consequences, or does it only describe actions for someone else to take?


Gartner has been blunt about how much of the market is currently confusing the two. The firm's own 2025 research on "agentic AI washing" estimated that only a small fraction of vendors marketing "agentic AI" products actually deliver systems capable of autonomous, multi-step action — most are conventional automation or a single LLM call with an agentic label attached (Gartner, "Agentic AI Washing," 2025). That gap between the marketing term and the architectural reality is precisely why this shift is worth naming carefully rather than assuming the industry has already made it.


Where genuine agentic systems have shipped, the results are hard to wave away. By Anthropic's own account, as of May 2026 more than 80% of the code merged into Anthropic's codebase was written by Claude — not suggested, merged (Data Science Dojo, "Recursive Self-Improvement in AI Agents," 2026). That statistic gets cited constantly in the context of AI coding tools, but the more interesting detail is what it implies about verification: that volume of autonomously written code only ships because the outcomes are checkable — tests pass or fail, builds succeed or fail — which lets a human supervise a fleet of agents by exception rather than by reviewing every line. That's the operating model agentic data engineering is reaching for: not fewer humans, but humans supervising outcomes instead of authoring every step.



Two versions of the same Tuesday

The clearest way to see the difference isn't in the abstract , it's in what happens on an ordinary Tuesday when something in the stack goes wrong.

Take schema drift, probably the single most common source of pipeline breakage. 


  • A source API adds a field, renames one, or quietly changes a data type. In the suggestion-layer version of a data team's Tuesday, a monitoring tool flags an anomaly — row counts look off, or a downstream dbt test starts failing — and pages an engineer. 

  • The engineer opens a chat window, describes the symptom, and gets back a plausible diagnosis and a suggested patch. 

  • They still have to confirm the diagnosis is actually right, trace which of the dozens of downstream models the schema change touches, write and run the backfill, and watch the redeploy. 

  • Best case, that's an hour of focused work by someone who was probably in the middle of something else. 

  • Worst case, it's the thing that gets triaged as "not on fire enough yet" and sits for a week while three reports quietly serve stale numbers.


In the agentic version, the same schema drift gets diagnosed the moment ingestion produces output that doesn't match the expected contract, not the next time someone happens to look at a dashboard. 


  • The system traces which downstream tables, models, and reports depend on the changed field, proposes a mapping for the new schema, runs the backfill against a validation gate that checks the output reconciles with the source, and redeploys. 

  • A human sees the change only if the new field is genuinely ambiguous say, a renamed column that could plausibly map to two different targets, in which case the system escalates with its reasoning attached, rather than either guessing silently or interrupting a person for something it could have resolved on its own.


The same contrast holds for documentation. 


  • Suggestion-layer tools are good at generating a first draft of documentation for an undocumented table when asked. They are not, by design, watching continuously for the moment three weeks later when someone changes the underlying transformation logic and the documentation quietly stops matching reality — that requires standing responsibility for keeping something correct, not a one-time answer to a one-time question. 

  • An agentic system with the same access can treat documentation as a property it maintains, not an artifact it produces once: detecting drift between what's documented and what the pipeline actually does, and correcting it as part of its ongoing work rather than waiting to be asked again.


Neither example required a more powerful model than the suggestion-layer tools already use. What changed is scope of responsibility ,whether the system is answering a question or owning an outcome.



Why data engineering is where this lands hardest?

Software engineering got here first, and for a specific reason: code is unusually verifiable. A test suite either passes or it doesn't. Data engineering shares that property almost uniquely among knowledge-work domains — arguably more so than general software, because a pipeline's correctness is measured continuously, in production, against real data, not just at merge time. A schema validation either holds or it doesn't. A freshness SLA is either met or it's breached. A row count either reconciles against the source or it doesn't. Null rates either stay under threshold or they don't. This is the same verifiability property that research on recursive self-improvement identifies as the precondition for any AI system to safely take autonomous action at scale and data pipelines were built with exactly that kind of check baked in for decades, long before anyone was thinking about agents (VentureBeat, "Spec-Driven Development Comes to AI Data Engineering," 2026).


That verifiability is also why the toil in data engineering has been so stubbornly resistant to past automation waves. The failure modes are specific and recurring in a way that's genuinely tractable for a system that can act, not just answer: documentation that's accurate the day it's written and stale within a quarter; lineage information that exists nowhere except one senior engineer's memory; ingestion pipelines that break silently after an upstream API changes a field type and keep "succeeding" while quietly producing incomplete or malformed data; a backlog of "we should really refactor this" tickets that never wins a prioritization fight against whatever's on fire. None of that is exotic. It's the ordinary maintenance load of running data infrastructure, and it has always scaled with headcount rather than with better tooling — because until now, the tooling could describe the problem but not resolve it.


An agent that can actually act on a verifiable domain changes the arithmetic. Consider ingestion: a suggestion-layer tool can flag "this API response shape changed" the same day a human would eventually notice it in a dashboard anomaly. An agentic system can diagnose the schema drift, map the new fields onto the canonical model, propose the backfill, run it against a validation gate, and only surface the change to a human when the mapping is genuinely ambiguous. The difference isn't detection speed — both systems can be fast. It's that one of them closes the loop and one of them hands the loop back to a person who's already got six other fires going.


The other half of the shift: governance has to move with it

There's a reason "give the AI more autonomy" makes a lot of engineering leaders nervous, and it's a legitimate reason: the moment a system can act on production data instead of just suggesting an action, the cost of a wrong action goes up substantially. A bad SQL suggestion wastes an analyst's time. A bad autonomous schema migration touches every downstream table that depends on it.

This is where the agentic shift and the governance conversation are actually the same conversation, not two separate ones. A system that only suggests doesn't need much runtime governance, because a human is the checkpoint by construction, every suggestion passes through a person before it has any effect. A system that acts needs governance built into the substrate it operates on, enforced as it works, not audited after the fact. That's a materially different design problem: access control, data classification, and policy enforcement have to be checked computationally at the moment of ingestion, transformation, and action — not reviewed in a retrospective compliance pass weeks later. 

Brighthive 's own framing of this is direct: governance isn't a report the harness generates, it's the substrate every agent operates within, enforced continuously and computationally as data is ingested, transformed, and analyzed. That's not a nice-to-have layered on top of agentic execution — it's the precondition that makes autonomous execution defensible in the first place.

It also reframes what "human in the loop" should mean in an agentic system. 


  • In the suggestion-layer world, the human was in the loop for everything, because everything required their action to have effect. 

  • In a well-built agentic system, the human is in the loop for judgment calls — the ambiguous schema mapping, the policy exception, the architectural decision — while the agent handles the high-volume, always-on maintenance work autonomously within governed boundaries. 

  • That's a pairing model, not a replacement model: a human sets direction and owns the outcome, while a fleet of agents does the repetitive work underneath, at a speed and consistency no human team could sustain on its own.


This is also why "one agent" was never really the right unit to design around, once you take the shift seriously. The work a data team actually does spans ingestion, quality monitoring, governance classification, pipeline engineering, root-cause analysis, and communicating findings back to the business — five or six distinct disciplines that happen to sit on the same underlying data. Brighthive approach to this is to run a seven-agent harness rather than a single generalist model: a supervisor agent — BrightAgent — orchestrates the work and hands off to a human specifically on judgment calls, while separate agents handle ingestion, quality, governance, engineering, analysis, and visualization against the same governed foundation. 

The architectural point generalizes past any one vendor's product: crossing from suggestion to action isn't a matter of giving one chatbot more permissions. It's a matter of building a system where each function that used to require a specific person's hands now has a specific agent accountable for it, operating inside the same policy boundary a human team would have to respect anyway.


Why most teams stall halfway across?

If the shift is this legible in theory, it's worth asking why most data organizations are still, in practice, standing on the suggestion side of the line. Part of the answer is architectural inertia: Airflow, Prefect, and similar orchestrators were built to schedule pipelines a human already wrote and will hand-maintain forever. 

They're excellent at running a DAG on time. They have no opinion about whether the DAG is still correct, whether the documentation describing it is still true, or who's supposed to notice when it isn't — because none of that was ever their job. Bolting a chatbot onto that stack answers questions faster; it doesn't change who's responsible for acting on the answers.


Part of the answer is also trust, and that part is legitimate rather than merely cultural. 

Handing an autonomous system write access to production pipelines is a genuinely different risk posture than handing it a chat window, and plenty of teams have watched an over-eager automation script cause exactly the kind of incident it was meant to prevent. 

Gartner's own warning about "agentic AI washing" cuts both ways here: some of the caution is healthy skepticism about a genuinely unproven category, and some of it is directed at products that never had the verification and rollback discipline to deserve the autonomy they were marketed with. The two get conflated constantly, and the result is that legitimate agentic systems — the ones with sandboxed verification gates, versioned rollback, and governed access boundaries built in from the start — get lumped in with agentic-in-name-only automation that earned the skepticism honestly.


The teams that do cross the line successfully tend to do it narrowly and verifiably first, not company-wide and all at once: one pipeline, one class of failure, one agent with a tightly scoped mandate and an unambiguous way to check whether its actions were correct. That's not a failure of ambition. It's the same discipline that made data pipelines verifiable in the first place — tests, contracts, quality gates — applied to the question of how much autonomy a system has earned, one demonstrated success at a time.


What "good" looks like operationally?

The practical test for whether a data team has actually crossed from suggestion to action isn't whether they've bought a tool with "agent" in the name. It's whether the failure modes that used to require a human's hands — not just a human's judgment — now get resolved without one. A few concrete markers:


Ingestion failures get diagnosed and, where the fix is unambiguous, remediated without a ticket sitting in a backlog for two weeks. Documentation that drifts from the actual pipeline logic gets caught and corrected continuously, rather than during the next audit or the next new hire's onboarding, whichever comes first. Lineage questions — "what breaks if I change this column" — get answered by querying a system that actually knows the dependency graph, not by messaging the one person who remembers. Access-policy violations get flagged and can be remediated as data flows, not discovered in a quarterly review. And critically, the human team's time shifts from firefighting the same categories of problem on a loop toward the judgment work that actually needed a person: deciding what the data platform should do next, not manually keeping it alive.


None of this argues that suggestion-layer tools were a wrong turn. They were a necessary and genuinely useful first step, and they'll keep a role for exploratory, judgment-heavy work where a human should always be the one deciding. What's changing is the ceiling. A tool that can only suggest has a hard limit on how much of a data team's maintenance burden it can absorb, because every suggestion still costs a human's attention to evaluate and execute. A system that can act, verify its own work against real checks, and escalate only the genuinely ambiguous cases has a much higher ceiling — bounded mainly by how well it's governed, not by how much attention it demands.


Frequently Asked Questions


  1. What is agentic data engineering? Agentic data engineering is the practice of using AI systems that autonomously diagnose, implement, test, and redeploy changes to data pipelines — schema fixes, documentation updates, quality remediation — within governed boundaries, rather than only suggesting those changes for a human to carry out.

  2. How is an agentic AI system different from an AI copilot for data teams? A copilot answers a question or drafts a suggestion and hands it back to a human to evaluate and execute; an agentic system takes the action itself, verifies the outcome against a check like a passing test or a reconciled row count, and only escalates to a human when the situation is genuinely ambiguous.

  3. Why is data engineering well-suited to agentic AI specifically? Data pipelines are unusually verifiable — schema validations, freshness SLAs, and row-count reconciliations either pass or fail — which gives an autonomous agent a clear, objective signal for whether its own action succeeded, the same property that makes recursive self-improvement and safe autonomous execution possible in software engineering.

  4. Does agentic AI replace data engineers? No — the pattern emerging across agentic AI adoption is pairing, not replacement: a human sets direction and owns outcomes while agents handle the high-volume, always-on maintenance work, with humans staying in the loop specifically for judgment calls rather than every routine fix.

  5. What has to be true for it to be safe to let an AI agent act autonomously on production data pipelines? Governance has to be built into the system as it works — access control, data classification, and policy enforcement checked computationally at the moment of ingestion and action — rather than reviewed after the fact, alongside verification gates and rollback so a failed autonomous change can be caught and reverted before it compounds.


That's the shift this series is going to track across the next fourteen weeks: not "AI helps you write pipelines faster," but what changes architecturally, operationally, and organizationally when the AI in your data stack is trusted to act — governed from the first pipeline run, verified continuously, and accountable for outcomes the way a team member is, not the way a search result is.


It's also worth naming where this shift is headed, because "agent that can act" is a starting point, not the destination. If a system can act on your pipelines and verify whether its actions worked, the next question is what tells it what "correct" means in the first place — which is precisely the question spec-driven data engineering exists to answer, and the subject of the next Brighthive Original piece in this series. And if that system is going to act autonomously at scale across a real production stack, it needs a representation richer than a task list to reason over — dependencies, semantics, ownership, quality rules — which is exactly the gap procedural graphs for data are built to close. Suggestion-to-action is the foundational move. What gets built on top of it — specs as the source of truth, richer representations for agents to reason over, agents that improve their own performance on your data — is where the next decade of this field is actually headed.


None of that arrives by accident, and none of it arrives by simply buying a tool with "agent" in the name. The teams that make the suggestion-to-action shift deliberately — starting narrow, verifying relentlessly, governing from the first pipeline run rather than retrofitting policy after the fact — are the ones who will actually close the gap between what their data infrastructure could do and what it's had the hours to do. The bottleneck was never talent. It's about to stop being hours, too.

 
 
 

Comments


2/16/26

|

Featured

Beyond Observability: The Rise of the Self-Healing Data Infrastructure

2/13/26

|

AI Trends & Innovations

The Future of Secure Data Sharing: Agentic, In-Place, and Compliant

1/23/26

|

Featured

Company Sovereignty in the AI Era: Why Brighthive's Architecture is Already Solving for What Nadella Says Leaders Must Consider

POPULAR ARTICLES

Share

Give your team the insights they need. Start for free today.

Begin a 7-day free trial of the full Brighthive platform, customized and secure with your organization's unique data and use cases. No credit card required.

bottom of page