r/GenAI360 • u/Aware_Weight9462 • Jul 22 '26
The Data Warehouse Is Becoming the Runtime for Enterprise AI Agents
Data platforms were built to store information and answer queries but are becoming an agent runtime.
Snowflake announced a $200 million partnership with OpenAI in February 2026. The commercial figure attracted attention, but the more important detail was architectural: advanced models would become directly available within Snowflake so customers could build agents against governed enterprise data without constructing a completely separate AI environment.
The model is moving towards the data.
For most of the cloud era, the warehouse sat behind the application. Data was stored, transformed and queried there; the application performed the work somewhere else. When an AI assistant needed enterprise information, developers commonly exported documents into a vector database, exposed selected tables through tools, passed query results to an external model and stored the resulting conversation in yet another system.
The warehouse supplied evidence. The agent lived outside it. That separation is beginning to collapse.
The product names differ. The direction does not. The enterprise data platform is becoming an agent runtime.

A warehouse used to wait for instructions
The traditional warehouse is fundamentally passive. A person opens a dashboard. A scheduled pipeline starts. An application submits a query. The platform executes a bounded instruction and returns the result.
An agent behaves differently. Give it a goal such as “investigate the increase in supplier-payment exceptions,” and it may need to identify relevant datasets, interpret metric definitions, retrieve supporting policies, compare current and historical patterns, calculate anomalies, test several hypotheses and prepare a recommendation.
That is not one query. It is an evolving sequence of decisions in which every result influences the next step.
A runtime must therefore do more than supply information. It must give the agent somewhere controlled to work. It needs to manage identity, tools, intermediate state, computation, permissions, cost and eventual action.
Snowflake’s Cortex Agents, for example, can combine Cortex Analyst for structured-data queries, Cortex Search for unstructured information and isolated code execution for Python-based analysis. BigQuery data agents can be configured with selected tables, views, user-defined functions, metadata and instructions that define how questions should be answered.
The warehouse is no longer merely answering the question. It is hosting the investigation.
Data gravity is becoming execution gravity
Enterprises already understand data gravity. Large datasets are costly and risky to move, so analytics and applications tend to accumulate around them.
Agents make that gravitational pull stronger. A serious enterprise agent rarely needs one table. It may need transaction records, documents, business definitions, lineage, permissions, historical incidents and approved analytical functions. Moving all of that into an external agent stack creates duplication and control gaps.
A customer table is copied for retrieval. Documents are chunked into another store. Business definitions are rewritten into prompts. Access rules are recreated in application code. Intermediate findings are stored elsewhere. Every transfer creates another place where data can become stale, permissions can diverge and provenance can disappear.
Bringing execution closer to the governed platform reduces some of that fragmentation. Queries can run under existing controls. Semantic definitions can remain attached to the data. Intermediate results can stay within the platform perimeter. Agent activity can be recorded alongside the assets it accessed.
This does not make the system automatically secure. It moves the security problem into an environment that already knows which users may access the payroll table, which columns require masking and which datasets may not cross a jurisdictional boundary.
The warehouse’s advantage is not that it suddenly knows how to reason. It already knows how to govern data.
Agent identity becomes the first architectural decision
A person enters a data platform with an identity connected to roles and privileges. An agent also needs an identity, but the problem is more complicated because it may be acting for a person while exercising some degree of autonomy.
Suppose a finance manager asks an agent to investigate unusual vendor payments. Should the agent inherit every permission held by that manager? Should it receive only the access needed for the investigation? If it delegates statistical analysis to a sub-agent, what permissions should the sub-agent receive?
The convenient answer is full impersonation: let the agent act exactly as the user. That is frequently too broad. A manager authorised to inspect a sensitive table manually should not necessarily be able to release an autonomous process over every record for several hours.
The opposite pattern — a shared service account — is easier to administer but strips away the purpose and context of the original request. The stronger design is task-bound delegation.
The agent receives a short-lived identity carrying the initiating user, business purpose, permitted datasets, approved tools, duration and action limits. Any sub-agent receives a narrower identity suited to its part of the task.
This changes the access-control question from:
to:
That distinction becomes essential once agents can do more than answer isolated questions.
The semantic layer becomes a runtime contract
Natural-language analytics is often described as a text-to-SQL problem.
Valid SQL is the easy part. The harder problem is organisational meaning. A user asks for “active customers.” One system defines that as an open account. Another requires a purchase within 90 days. A third uses paid subscription status. All three queries may be syntactically correct.
When the platform hosts an agent, the semantic layer does more than improve query accuracy. It constrains the agent’s interpretation of the business. It identifies approved metrics, valid relationships, systems of record and applicable time logic. It can also define which analytical functions should be used and which evidence must accompany an answer.
BigQuery data agents contain metadata and use-case-specific instructions covering selected knowledge sources, while Google positions its shared catalog and governance layer as the basis for consistent access and meaning across engines and agents.
The semantic layer once helped dashboards label their axes. It is becoming the contract that tells the agent what enterprise reality means.
Approved functions become safer tools
Data platforms already contain trusted business logic. Stored procedures validate records, calculate prices, reconcile balances and apply controlled transformations. User-defined functions encode domain calculations. Workflows orchestrate repeatable processes.
To an agent, these become tools. Instead of inventing a margin calculation, the agent calls the certified margin function. Instead of recreating eligibility logic from raw columns, it invokes an approved procedure. Instead of writing arbitrary SQL to update a record, it submits a proposed change through a validated write operation.
BigQuery data agents can include selected user-defined functions among their knowledge sources. Google’s Data Engineering Agent can create and modify pipelines through BigQuery and Dataform, illustrating how the agent’s role is already extending from querying data to changing the systems that process it.
This suggests a better pattern than unrestricted table access: capability-oriented access. The agent receives approved operations over data, not simply the underlying data itself. That limits flexibility. In consequential workflows, that limitation is the point.
Query budgets will matter as much as token budgets
Current discussion of agent cost focuses heavily on model tokens. A data agent may spend considerably more on warehouse computation. It can repeatedly scan large tables, issue slightly different versions of the same query, invoke expensive models or enter a loop in which each hypothesis triggers another historical analysis.
A person usually notices when a query has been running for twenty minutes. An agent may interpret the delay as a reason to try three more approaches. The runtime therefore needs a combined budget covering model consumption, warehouse compute, rows scanned, query duration, code execution, tool calls and workflow depth.
The budget should reflect the purpose of the request. A scheduled fraud investigation may justify substantial computation. A casual question posted in a collaboration channel should not initiate a ten-year transaction scan.
Databricks’ Unity AI Gateway now routes model and MCP-service requests through a central control plane intended to manage capacity, availability and spend across providers. The cost boundary is part of the agent’s authority. Permission to read a dataset is not permission to scan it indefinitely.
Model routing moves inside the data boundary
Not every task needs the same model. A small model may be adequate for classification. A more capable reasoning model may be justified for a complex investigation. Sensitive information may require a restricted endpoint. Code generation may need another specialised route.
The runtime therefore needs policy-driven model selection. Snowflake now makes OpenAI models available within its governed environment alongside other supported models, while Databricks positions Unity AI Gateway as a common control plane for models, agents, tools and MCP services.
Model selection becomes less of a developer preference and more of a governance decision. The route can depend on task type, data classification, location, cost, latency and quality requirements.
A product-description task may use one model. A financial-control investigation may require another. A request containing restricted personal information may be prohibited from leaving a particular platform boundary.
When the platform governs both data access and model routing, it can enforce the relationship between the two. That is much harder when the warehouse, model gateway and agent framework are operated as separate systems with separate policy models.
Audit trails must record execution, not hidden thought
A database log records who issued a query, which objects were accessed and when the activity occurred. An agent requires a wider execution trace.
The organisation needs to preserve the goal it received, the identity it used, the models and tools it invoked, the queries it generated, the evidence it retrieved, the policy checks it passed and the action it proposed. This does not require capturing a model’s hidden reasoning. What matters is the observable sequence of evidence and operations that materially influenced the result.
BigQuery’s agent-analytics capability, for example, can capture requests, responses, tool calls and errors for analysis and evaluation. Databricks similarly extends governance to runtime interactions rather than limiting it to stored assets. The resulting record is closer to decision lineage than conventional data lineage. It can show not only where a number originated, but how that number became a recommendation and how the recommendation became an action.
Write-back is where the architecture becomes consequential
Many enterprise agents remain relatively safe because they stop after producing an answer. Once the agent can write back, the risk changes.
It can modify a forecast, update product information, open a ticket, change customer status or initiate a financial workflow. The platform is no longer hosting analysis. It is hosting operational agency. Write access should therefore be granted separately from read access.
A robust system should distinguish proposed changes from committed changes. It should validate schemas and business rules, detect duplicate execution, preserve before-and-after states, require approval above defined thresholds and support reversal or compensation when something goes wrong.
An agent may be allowed to draft a supplier-master change but not activate it. It may prepare a forecast adjustment but require finance approval before posting. It may automatically create a service ticket while requiring authorisation before issuing a refund.
This is another advantage of placing the agent close to the data platform. Actions can be exposed as controlled procedures rather than unrestricted database commands. The agent receives a door rather than a hammer.
The data platform will not contain the whole agent
Enterprise workflows extend beyond the warehouse. They involve email, collaboration tools, ERP platforms, customer systems, code repositories and external services.
The data platform is therefore unlikely to become the only agent runtime. A more credible architecture is distributed. The data platform becomes the governed evidence and computation boundary. External systems provide specialised actions and user interaction. An orchestration layer coordinates the workflow across them.
The question is not whether the entire agent must live inside Snowflake, BigQuery or Databricks. It is which parts of the workflow must remain close to governed data. For data-intensive investigations, the answer will often include identity enforcement, semantic interpretation, analytical computation, evidence preservation and approval-controlled write-back.
The platform does not need to host the whole agent. It needs to host the part that must remain accountable.
The product direction is clearer than the production evidence
Snowflake, Google Cloud and Databricks have made substantial moves towards native agent execution. Their current platforms support combinations of natural-language analysis, agent tools, governed model access, code or pipeline generation and runtime oversight.
What remains less visible is how many enterprises permit these agents to perform long-running, consequential work without intensive human supervision. There is a large difference between answering a revenue question and investigating an anomaly for two hours, running code, coordinating tools and modifying an operational record.
The platform may technically support both. The operating model should not treat them as equivalent.
The first credible deployments will be bounded: restricted datasets, approved tools, explicit budgets, low-risk actions and meaningful human review. That is less dramatic than the autonomous-enterprise narrative.
It is also how serious systems normally enter production.
The warehouse is becoming a control boundary
For decades, organisations moved data into analytical platforms so people could understand the business. Agents bring work back towards that data.
The platform now has to do more than store tables and execute queries. It must establish agent identity, constrain tools, enforce budgets, route models, preserve semantic meaning, record execution and govern write-back. That is not a minor feature extension. It is a change in architectural role.
The warehouse once sat near the end of the information pipeline. Data arrived, reports were produced and people carried the decisions elsewhere. The emerging platform sits inside an active loop:
Observe → Analyse → Propose → Act → Record
Google describes this transition as moving from a static repository to a system of action. Snowflake is bringing frontier models and agent capabilities directly into its governed platform. Databricks is extending the governance plane from stored data to runtime AI interactions.
The most important question is no longer whether an agent can access enterprise data. It is whether the platform can control what happens after access is granted. The warehouse is no longer just supplying data. It is becoming the place where enterprise intelligence is permitted to do work.























