AIToday
Large Language ModelsAI Coding AssistantsZenn AI/MLPublished: Oct 19, 2026, 22:00 JST

Data Science Agent runs BigQuery ML from features to eval

Data Science Agent runs BigQuery ML from features to eval

3 Key Points

  1. What happened

    A walkthrough of Data Science Agent in BigQuery Studio used analytics.ec_orders (1,234,567 rows) to define a 90-day repeat-purchase label and train a LOGISTIC_REG model called repeat_predictor_v1.

  2. Why it matters

    The agent generated the SQL for feature creation, model training and prediction from natural-language prompts, removing the need to look up BigQuery ML syntax and letting users focus on feature design and model interpretation.

Not sure about something? Ask the AI

Questions and answers are published on this page.

Summaries like this, in your inbox every morning.

Context & Analysis

The walkthrough illustrates how BigQuery's Data Science Agent fits alongside other agents in BigQuery Studio—Data Engineering Agent for pipelines, Data Preparation Agent for cleansing and Conversational Analytics for exploration—so users can route each task to the appropriate helper. It also highlights practical cautions: generated SQL must be checked for data leakage between features and the target, the default 0.5 threshold should be adjusted to favor recall or precision depending on the campaign, and training costs scale with data volume, so asking the agent for a dry-run estimate beforehand helps with cost control. The agent's ability to produce a v2 model with added features and compare metrics against v1 suggests an iterative improvement loop driven by natural-language prompts.

FAQ
What permissions do I need to use Data Science Agent?
You need the IAM roles roles/bigquery.dataEditor, roles/bigquery.jobUser, roles/bigquery.connectionUser and roles/aiplatform.user. A Vertex AI connection setup is also required.
What evaluation metrics did the walkthrough's model report?
The model reported precision 0.71, recall 0.68, AUC-ROC 0.79 and an F1 score of 0.69 on test data from 2026-01-01 onward.
How can I improve the model after the first run?
You can ask the agent to add features such as GA4 session counts, switch model types to BOOSTED_TREE or DNN_CLASSIFIER, or adjust regularization, and the agent will generate the corresponding SQL.

AI news that matters for your work, delivered every morning.

Pick your industry and the AI tools you use, and get news related to your work every day.

Free · 30 seconds with Google · unsubscribe anytimeWhat is AIToday? →

Ask AI

Ask AI anything about this article. The AI reads this article, earlier AIToday articles, and Wikipedia, and cites its sources. Q&As are published on this page for other readers too.

Questions and answers are published on this page.

Related Articles

Next articlePax8 launches 8os to govern AI agents for IT partners