BigQuery
Serverless data warehouse with built-in ML and Gemini
BigQuery is a fully managed, serverless data platform from Google Cloud for storing, managing and analyzing data with SQL or Python. Storage and compute are separate layers that scale independently, and no infrastructure needs provisioning. BigQuery ML builds, trains and deploys models using SQL, including linear and logistic regression, k-means and ARIMA+ forecasting. Gemini in BigQuery assists with insights, natural-language chat with data, and generating or explaining SQL and Python. Generative AI integration and vector search support semantic workloads. It can query external data in Cloud Storage, Bigtable, Spanner and Google Sheets, and connects to Looker, Tableau and Power BI.
- Filed under
- Data & Analytics
- Pricing
- Freemium
- Platforms
- web · api
- Last updated
- November 10, 2026
What BigQuery does
- BigQuery ML. Build, train and deploy machine learning models using SQL.
- Gemini in BigQuery. Chat with data, generate and explain SQL and Python, and recommend data transformations.
- Vector search. Run semantic search and use large language models within data workflows.
- BigQuery DataFrames. pandas-compatible Python API for data analysis.
- Federated queries. Query data in Cloud Storage, Bigtable, Spanner and Google Sheets without moving it.
- Streaming ingestion. Real-time loading through the Storage Write API, plus batch and transfer service options.
Who it’s for
- Teams analyzing large datasets on Google Cloud with SQL
- Analysts who want to train models without leaving SQL
- Organizations feeding BI tools like Looker or Power BI
BigQuery pricing
Free sandbox and free tier with 1 TiB of query processing per month; on-demand and capacity-based pricing; see the pricing page for rates
As listed on November 9, 2026. Check cloud.google.com for current prices.
Things to know
- Sandbox has a 10 GiB lifetime storage cap and tables expire after 60 days
- Sandbox does not support streaming, DML statements or the Data Transfer Service
Quick answers
- What is BigQuery?
- BigQuery is a fully managed, serverless data platform from Google Cloud for storing, managing and analyzing data with SQL or Python.
- Is BigQuery free?
- BigQuery is billed by usage, with a free allowance to start. (As listed on November 9, 2026.)
- Who makes BigQuery?
- BigQuery is made by Google Cloud.
- Where can you use BigQuery?
- BigQuery is available on the web and an API for developers.
- What are some alternatives to BigQuery?
- Other tools filed in the same section include Google Colab, IBM watsonx.ai and Hex.
Tags
See also
Cross-referenced entriesGoogle Colab
Hosted Jupyter notebooks with free GPUs and Gemini
jupyternotebooksgpu
IBM watsonx.ai
Enterprise studio for predictive and generative AI
foundation-modelsragdecision-optimization
Hex
AI analytics workspace with SQL and Python notebooks
notebookssqlpython
Deepnote
Collaborative Python and SQL data notebooks with AI
notebookspythonsql