Google Introduces Natural Language Data Preparation in BigQuery with Gemini

January 22, 2025 at 6:07:05 AM

TL;DR Google has integrated Gemini with BigQuery Studio for natural language data preparation, allowing users to transform data using conversational prompts instead of SQL queries. Key features include automated suggestions, contextual recommendations, and SQL generation from natural language. The platform supports filtering, column management, and join operations, simplifying workflows for users without extensive SQL expertise.

Google Introduces Natural Language Data Preparation in BigQuery with Gemini

Google has announced the integration of Gemini with BigQuery Studio, enabling natural language data preparation capabilities. This new feature allows users to transform and prepare data using conversational prompts rather than traditional SQL queries.

Key Features

Automated Suggestions

  • Gemini automatically inspects loaded data and schema
  • Generates contextual transformation suggestions
  • Provides column-specific and cell-specific recommendations

Natural Language Processing

  • Users can edit and fine-tune suggestions using natural language
  • Supports data transformation through conversational prompts
  • Allows SQL expression generation from natural language descriptions

Data Preparation Capabilities

The platform offers several key preparation functions:

  • Transformations: Convert data formats using simple language commands
  • Filtering: Apply data filters through natural language descriptions
  • Column Management: Delete and modify columns with intuitive controls
  • Join Operations: Combine data sources with guided assistance
  • Validation Rules: Create error handling and data validation steps

User Experience

The interface provides multiple ways to interact with data:

  • Preview capabilities before applying changes
  • Step-by-step data preparation tracking
  • Full-screen mode for enhanced visibility
  • Interactive data sample viewing
  • Error table configuration for validation tracking

This integration represents Google's effort to simplify data preparation workflows by making BigQuery more accessible to users without extensive SQL expertise.

Have more questions on this topic? Ask our AI assistant for in-depth insights.

Read more from sources 👇

The Only Digital Marketing Feed You'll Ever Need.

Stay informed your way. Tailored updates when and how you want them. 100% Free.

10,000+ Users

500+ Sources

1000+ Tools

Or

Related Posts

Gemini Assistant Launches in BigQuery Data Canvas for Enhanced Data Analytics

Gemini Assistant Launches in BigQuery Data Canvas for Enhanced Data Analytics

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Gemini Advanced users can now create and share videos with Veo 2 starting today

Gemini Advanced users can now create and share videos with Veo 2 starting today

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Marketing Workflow Templates

Marketing Workflow Templates

Featured
Markifact
Markifact

Verified Sponsor

Verified Sponsor

Markifact is a Verified Sponsor. Want to get featured here? Contact us.

Verified Sponsor
BigQuery ML Now Supports Llama and Mistral Models for Advanced Text Generation

BigQuery ML Now Supports Llama and Mistral Models for Advanced Text Generation

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Google removes 240 million fake reviews in 2024 thanks to Gemini

Google removes 240 million fake reviews in 2024 thanks to Gemini

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Google's Complete March AI Changelog: Gemini 2.5 Pro and Beyond

Google's Complete March AI Changelog: Gemini 2.5 Pro and Beyond

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source
BigQuery Introduces Metadata Caching for SQL Translation

BigQuery Introduces Metadata Caching for SQL Translation

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Google Launches New Travel Features for Search Maps Lens and Gemini

Google Launches New Travel Features for Search Maps Lens and Gemini

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source

Related Tools

Markifact logo

Markifact

Verified Tool

Verified Tool

Markifact is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Marketing Workflows Powered by AI

Featured
Marketing Auditor logo

Marketing Auditor

Verified Tool

Verified Tool

Marketing Auditor is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Automated audits for Google Ads and Analytics.

Get Featured Here

Showcase your tool in this list.

Contact Us
Databricks logo

Databricks

Generative AI-powered data intelligence platform

Data Engineering
GA4 SQL logo

GA4 SQL

Verified Tool

Verified Tool

GA4 SQL is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Generate GA4 BigQuery queries easily

Data Analysis
TapClicks logo

TapClicks

Automated marketing solutions powered by your data

Data Engineering
Stitch logo

Stitch

Automated cloud data pipelines, no coding needed

Data Engineering
Akkio logo

Akkio

AI-powered analytics for agencies

Data Analysis
NinjaCat logo

NinjaCat

AI-powered marketing data and analytics platform

Reporting
Funnel logo

Funnel

Aggregate and analyze marketing data seamlessly

Reporting
Fivetran logo

Fivetran

Effortlessly centralize and move data from any source

Data Engineering

Get Featured Here

Showcase your tool in this list.

Contact Us