Skip to main content
ai-ml

From Weeks to Minutes: Google Cloud Introduces Data Agent Kit for Agentic Data Pipelines

Google Cloud has introduced the Data Agent Kit, an open-source toolkit that brings agentic data engineering into IDEs and CLIs, helping teams author, deploy and troubleshoot Apache Airflow pipelines using natural language and declarative YAML.

Xcademia Team

Xcademia Research Team

Sep 01, 202610 min read9 views
Share:
From Weeks to Minutes: Google Cloud Introduces Data Agent Kit for Agentic Data Pipelines

Google Cloud Brings Agentic Data Pipeline Development Into the IDE

Google Cloud has introduced the Data Agent Kit, an open-source collection of data engineering and data science tools designed to bring data pipeline development directly into developers' preferred IDEs and command-line environments. The announcement follows Google's introduction of the Orchestration Pipelines framework at Google Cloud NEXT '26.


According to Google Cloud, the Data Agent Kit integrates the orchestration framework into environments such as VS Code, Claude Code and Codex, allowing data professionals to author, deploy and troubleshoot production-grade Apache Airflow DAGs using natural language.


The approach is built around two key components.

The first is a dedicated Data Engineering tab for pipeline management.

The second is an agentic skill designed to help users author, deploy and troubleshoot Airflow DAGs.

Google Cloud also combines these capabilities with a declarative YAML DSL, allowing users to describe pipeline logic without having to write all of the underlying Python Airflow boilerplate manually.

The company demonstrates the approach through an MLOps example involving delivery-time prediction, automated inference and model drift evaluation.


What Is the Data Agent Kit?

The Data Agent Kit is described by Google Cloud as a unified, freely available and open-source collection of data engineering and data science tools.

It is designed to work inside an existing development workflow rather than requiring data professionals to move between separate interfaces for pipeline authoring, deployment and troubleshooting.


Google Cloud says the kit can be used with IDEs and CLI environments including:

  • VS Code

  • VS Code forks

  • Antigravity

  • Claude Code

  • Antigravity CLI

  • Codex

The toolkit embeds the Orchestration Pipelines framework into these environments.

The framework separates high-level orchestration logic from the underlying compute execution.

Instead of requiring every pipeline workflow to be expressed through Python-based Airflow operators, users can define orchestration through YAML and interact with the development environment using natural language.

Google Cloud positions this approach as a way to make pipeline orchestration accessible to a broader range of data professionals, including analysts and ML engineers.


How the Agentic Pipeline Workflow Works

The workflow described by Google Cloud begins inside a compatible development environment.

After installing and authenticating the Data Agent Kit, users can enable the gcp-pipelines-orchestration skill.


Google Cloud says this skill provides the agent with contextual knowledge about:

  • Pipeline syntax

  • Variable substitution

  • Secret management

  • Automated incident diagnosis for Airflow runs

Once the skill is enabled, users can begin authoring orchestration pipelines using natural language.

The company demonstrates this with an MLOps scenario where a single prompt is used to describe a continuous feedback loop.


The Data Agent Kit then generates the underlying:

  • PySpark scripts

  • dbt configurations

  • Declarative YAML pipelines

Google Cloud notes that model responses can vary depending on model versions, workspace context and token depth.

If an initial response leaves out a parameter, dataset path or dependency, users can provide a follow-up prompt.


info-1


Three Pipelines Form the Core Architecture

The demonstration is divided into three declarative orchestration pipelines.


They represent three stages of the MLOps workflow:

  1. Training

  2. Daily inference

  3. Automated evaluation and retraining

Together, these pipelines demonstrate how the framework can connect data preparation, machine learning execution, evaluation and conditional orchestration.


Pipeline 1: The Training Engine

The first pipeline acts as the heavy-compute portion of the demonstration.

According to Google Cloud, the generated pipeline first queries BigQuery to extract historical completed orders.

It then provisions Managed Service for Apache Spark serverless compute to calculate geographical distances and train the model.

Finally, the trained model is uploaded to the Gemini Enterprise Agent Platform Model Registry.


The source provides the following YAML definition:

modelVersion: "1.0"
pipelineId: "training-pipeline"
runner: airflow
owner: "mlops"
tags:
  - "job:datacloud:antigravity"
defaults:
  projectId: "your-project-id"
  location: "us-central1"
  executionConfig:
    retries: 0

actions:
  - sql:
      name: "extract_training_data"
      engine:
        bigquery:
          location: "US"
          destinationTable: "your-project-id.mlops.training_dataset"
      query:
        path: "blogpostdemo/training_query.sql"

  - pyspark:
      name: "train_model_dataproc"
      dependsOn:
        - "extract_training_data"
      engine:
        dataprocServerless:
          location: "us-central1"
          resourceProfile:
            inline:
              runtimeConfig:
                version: "2.3"
                properties:
                  "spark.dataproc.driverEnv.PYTHONPATH": "./libs/lib/python3.11/site-packages"
                  "spark.executorEnv.PYTHONPATH": "./libs/lib/python3.11/site-packages"
      mainFilePath: "blogpostdemo/train_model.py"
      environment:
        requirements:
          inline:
            list:
              - "tensorflow==2.14.1"
              - "numpy<2.0.0"
              - "protobuf<5.0.0dev"
              - "google-cloud-storage"

  - ai:
      name: "upload_model_vertex"
      dependsOn:
        - "train_model_dataproc"
      agentPlatform:
        projectId: "your-project-id"
        location: "us-central1"
        modelUpload:
          modelName: "transit_days_predictor"
          modelArtifactUri: "gs://your-bucket-name/models/tf_transit_days_model"
          servingContainerImageUri: "us-docker.pkg.dev/vertex-ai/prediction/tf2-cpu.2-14:latest"

The pipeline establishes dependencies between the individual actions.

The training data extraction must complete before the PySpark training stage begins.

The model upload then depends on the training stage.

This creates a defined sequence:

BigQuery extraction → Spark processing and training → Model upload


Pipeline 2: Daily Inference

The second pipeline handles the operational inference workflow.

Instead of retraining the model, this pipeline applies the existing model to currently in-transit orders.

The workflow:

  1. Extracts inference data through BigQuery.

  2. Runs batch prediction.

  3. Writes the prediction results back into BigQuery.

Google Cloud describes the output as a way to identify potential SLA breaches for the customer support team.


The source provides this YAML:

modelVersion: "1.0"
pipelineId: "inference-pipeline"
runner: airflow
owner: "mlops"
tags:
  - "job:datacloud:antigravity"
defaults:
  projectId: "your-project-id"
  location: "us-central1"
  executionConfig:
    retries: 0

actions:
  - sql:
      name: "extract_inference_data"
      engine:
        bigquery:
          location: "US"
          destinationTable: "your-project-id.mlops.inference_dataset"
      query:
        path: "blogpostdemo/inference_query.sql"

  - ai:
      name: "run_vertex_batch_prediction"
      dependsOn:
        - "extract_inference_data"
      agentPlatform:
        projectId: "your-project-id"
        location: "us-central1"
        batchInference:
          jobDisplayName: "inference_job"
          modelName: "projects/your-project-id/locations/us-central1/models/your-model-id"
          bigquerySource: "bq://your-project-id.mlops.inference_dataset"
          bigqueryDestinationPrefix: "bq://your-project-id.mlops"

Here, the dependency is straightforward.

The inference job starts after the BigQuery extraction stage.

The resulting prediction output is directed back into BigQuery.

This creates the operational path:

BigQuery inference data → Batch prediction → BigQuery results


Pipeline 3: Automated Evaluation and Branching

The third pipeline introduces automated evaluation and conditional orchestration.

The pipeline triggers dbt models that compare predictions against actual delivery timestamps.

The evaluation calculates absolute errors and SLA breaches.

The resulting metrics are then checked against an acceptable threshold.

If the model's error rate exceeds that threshold, the workflow can trigger the training pipeline again.


The source provides this YAML:

modelVersion: "1.0"
pipelineId: "evaluation-pipeline"
runner: airflow
owner: "mlops"
tags:
  - "job:datacloud:antigravity"
defaults:
  projectId: "your-project-id"
  location: "us-central1"
  executionConfig:
    retries: 0

actions:
  - pipeline:
      name: "run_dbt_models"
      framework:
        dbt:
          airflowWorker:
            projectDirectoryPath: "blogpostdemo/dbt_project"

  - python:
      name: "check_retraining_condition"
      dependsOn:
        - "run_dbt_models"
      mainFilePath: "blogpostdemo/evaluate_drift.py"
      pythonCallable: "check_drift"
      engine:
        local: {}

  - orchestrationPipeline:
      name: "trigger_retraining_pipeline"
      dependsOn:
        - "check_retraining_condition"
      pipelineId: "training-pipeline"
      bundleId: "my-first-bundle"
      waitForCompletion: false

The three pipelines therefore create a feedback loop:

Training → Inference → Evaluation → Conditional Retraining

This is the central MLOps architecture demonstrated in the Google Cloud announcement.


info-2


Deployment Through CI/CD

Google Cloud says authoring pipeline logic is only part of the process.

The pipelines also need to be deployed to a production environment.

With Orchestration Pipelines, the deployment process is integrated with standard CI/CD practices.


According to the announcement, the Data Agent Kit can automatically generate continuous integration workflows for the workspace, including workflows such as GitHub Actions.

The pipeline bundle can then be packaged and deployed to the Managed Airflow environment.


Google Cloud describes the workflow as allowing users to commit their changes and have the orchestration pipeline bundle deployed through the configured CI/CD process.

The company also points users to its deployment documentation for integrating these workflows with existing CI/CD environments.


Monitoring Pipelines From the IDE

The Data Agent Kit is not limited to pipeline creation.

Google Cloud also highlights day-two operations, including monitoring.

The Data Agent Kit brings the orchestration control plane into the IDE, allowing users to monitor Managed Airflow runs without constantly switching to a browser-based interface.

The source includes visuals showing:

  • Real-time monitoring of Managed Airflow runs

  • Visualization of the created pipeline

This keeps pipeline development and operational monitoring within the same development environment.


Agentic Troubleshooting for Failed Pipelines

Pipeline failures can occur for different reasons.

Google Cloud gives examples including a Managed Spark cluster encountering an out-of-memory exception because of a seasonal data increase, or a BigQuery quota being reached.

The Data Agent Kit provides an agentic troubleshooting workflow for these situations.

When a pipeline fails, users can select Troubleshoot within the IDE.

The Data Engineering Agent analyzes the available failure context.


Google Cloud says the agent can distinguish between infrastructure quota issues and code-level problems and provide a root-cause summary.

It can also suggest an inline fix, such as scaling up a compute template.

The announcement presents this as part of the broader goal of bringing development, deployment, monitoring and troubleshooting into one agent-assisted workflow.


info-3


What Changes for Data Engineering Teams?

The Google Cloud announcement focuses on reducing the amount of manual orchestration work required to build the demonstrated workflow.


Traditionally, an MLOps architecture can involve multiple layers, including:

  • Data extraction

  • Data transformation

  • Compute provisioning

  • Model training

  • Model registration

  • Batch inference

  • Evaluation

  • Drift detection

  • Conditional retraining

  • Deployment

  • Monitoring

  • Troubleshooting

The Data Agent Kit brings these activities into an agent-assisted development workflow.

Instead of manually building every orchestration component from scratch, users can describe the intended workflow and have the agent generate the required artifacts.

The use of declarative YAML also separates the high-level orchestration definition from the underlying compute execution.

Google Cloud says the example demonstrates how this can move the workflow from weeks of platform engineering work to a matter of minutes.

That statement refers specifically to the demonstrated example and should not be interpreted as a universal deployment time for every production pipeline.


Natural Language Does Not Remove the Need for Validation

Google Cloud also provides an important qualification in its announcement.


The company notes that responses from frontier models can vary based on factors such as:

  • Model version

  • Workspace context

  • Token depth

As a result, a generated workflow may occasionally omit a parameter, dataset path or dependency.

Google Cloud recommends providing a short follow-up prompt when this happens.

The company also describes the showcased pipeline as a simplified example designed to demonstrate Orchestration Pipelines capabilities.


Production MLOps architectures will vary according to individual use cases and operational requirements.

That distinction is important.

The Data Agent Kit can assist with authoring and troubleshooting, but the source does not state that human validation, testing or production engineering requirements have been eliminated.


A Broader Shift Toward Agentic Data Engineering

The announcement reflects a broader movement toward using AI agents as interfaces for technical workflows.

In the demonstrated architecture, the agent is not simply generating isolated code.

It works across multiple stages of a data and ML workflow, including pipeline authoring, configuration, deployment and troubleshooting.

The result is an approach where natural language becomes an interface for describing orchestration requirements, while YAML and underlying cloud services provide the execution structure.


For data teams, this could make complex orchestration workflows easier to approach for professionals who may not specialize in Airflow or Python-based pipeline development.

However, the practical impact will depend on factors such as workflow complexity, validation requirements, organizational controls and the reliability of generated configurations.

The Google Cloud announcement does not provide independent measurements establishing how much development time organizations will save across different production environments.


What the Example Connects

The MLOps demonstration brings several technologies together within one orchestration workflow.

Component

Role in the demonstrated workflow

Data Agent Kit

Agent-assisted development, monitoring and troubleshooting

Orchestration Pipelines

Declarative pipeline orchestration

Apache Airflow

Pipeline execution framework

BigQuery

Data extraction and storage

Managed Service for Apache Spark

Data processing and model training

Gemini Enterprise Agent Platform

Model registry and inference operations in the example

dbt

Evaluation and transformation

CI/CD workflows

Pipeline deployment

IDE / CLI

Development and operational interface


This combination is central to Google's demonstration of an agentic data engineering workflow.

Why This Announcement Matters

The most notable aspect of the announcement is not simply another pipeline authoring interface.

Google Cloud is positioning the Data Agent Kit around a broader development model in which an AI agent participates throughout the pipeline lifecycle.


The workflow begins with natural-language requirements.

It moves into pipeline generation and configuration.

The resulting workflow can then be deployed through CI/CD, monitored inside the IDE and investigated through agentic troubleshooting when failures occur.

That creates a more continuous relationship between data engineering and AI-assisted development.

The announcement highlights a broader industry shift toward making complex infrastructure workflows accessible through natural-language interfaces while retaining structured definitions underneath.


For enterprises, this could reduce some of the friction involved in creating and maintaining data workflows, particularly where repetitive orchestration code is involved.

At the same time, the source's own qualification around model variability and production architecture reinforces the need for validation and engineering oversight.


Conclusion

Google Cloud has introduced the Data Agent Kit as an open-source toolkit for bringing agentic data engineering into IDE and CLI environments.

The toolkit integrates with the company's Orchestration Pipelines framework and allows users to work with declarative YAML while using natural language to author, deploy and troubleshoot Apache Airflow-based workflows.


Google Cloud demonstrates the approach through a supply chain MLOps example that combines BigQuery, Managed Service for Apache Spark, Gemini Enterprise Agent Platform and dbt.

The demonstration uses three connected pipelines covering model training, daily inference and automated evaluation with conditional retraining.

The workflow can then be deployed through CI/CD and monitored from within the IDE. When failures occur, the Data Engineering Agent can analyze the failure context and suggest potential fixes.

The announcement represents a move toward more agent-assisted data engineering, where AI participates not only in writing individual pieces of code but also in orchestrating broader data and ML workflows.


Google Cloud says the demonstrated workflow can be authored and deployed in minutes rather than the weeks traditionally associated with building comparable orchestration logic. However, the company also makes clear that the example is simplified and that production MLOps implementations will vary by use case.

For now, the Data Agent Kit provides Google Cloud's latest example of how agentic development is moving deeper into the data engineering lifecycle.

#GoogleCloud#DataAgentKit#DataEngineering#MLOps#ApacheAirflow#AI#DataPipelines#MachineLearning

About the Author

X
Xcademia Team
Xcademia Research Team
Share:
Build the systems making these headlinesAI Engineer Bootcamp: live cohorts enrolling now, with optional Career+ support.