Agents Lookup

Use cases / Data & analytics

Data cleaning suggestions for a new source table

Open a raw table in a data prep tool and get suggested cleaning and transformation steps that an analyst accepts one at a time.

DifficultyBeginner
Setup timeUnder 1 hour
CategoryData & analytics

The use case

Raw tables from new sources come with mixed date formats, stray whitespace and inconsistent codes. BigQuery data preparation uses Gemini to look at the data and suggest cleaning, transformation and enrichment steps, which the analyst can accept, edit or reject. Accepted steps become a reusable pipeline that can be scheduled. The analyst still checks each step on sample rows, makes sure nothing drops valid data, and documents choices like how missing values are filled. Writing down why each step exists makes the pipeline easier for the next person to trust.

Example workflow

  1. Open a raw table in data preparation
  2. Review suggested cleaning steps
  3. Accept, edit or reject each step
  4. Check results on sample rows
  5. Save and schedule the pipeline

Tools

Risks and guardrails

Sources

Written by Agents Lookup. Credits and official pages for the tools this use case names: