BigQuery
From data warehouse to a unified, AI-
ready data platform
BigQuery is a fully managed, AI-ready data analytics platform that
helps you maximize value from your data and is designed to be multi-
engine, multi-format, and multi-cloud.
Store 10 GiB of data and run up to 1 TiB of queries for free per
month. New customers also get $300 in free credits to try BigQuery
and other Google Cloud products.
FEATURES
Power your data agents with Gemini in BigQuery
Gemini in BigQuery provides AI-powered assistive and collaboration features,
including code assist, visual data preparation, and intelligent
recommendations that help enhance productivity and optimize costs.
BigQuery provides a single, unified workspace that includes a SQL,
a notebook, and a NL-based canvas interface for data practitioners of various
coding skills to simplify analytics workflows from data ingestion and
preparation to data exploration and visualization to ML model creation and
use.
Bring multiple engines to a single copy of data
Introducing BigQuery Engine for Apache Flink, now in preview, for real-time
data streaming in BigQuery. This adds to its multi-engine capabilities that also
includes serverless Apache Spark. A unified metastore for shared runtime
metadata provides unified security and governance controls across all
engines and storage types. By bringing multiple engines, including SQL,
Spark, Python, and now Flink to a single copy of data and metadata, you can
break down data silos and increase efficiency.
Manage all data types and open formats
Use BigQuery to manage all data types across clouds, structured and
unstructured, with fine-grained access controls. Support for open table
formats gives you the flexibility to use existing open source and legacy tools
while getting the benefits of an integrated data platform. BigLake, BigQuery’s
storage engine, lets you have a common way to work with data and
makes open formats like Apache Iceberg, Delta, and Hudi. Read new
research on BigQuery's Evolution toward a Multi-Cloud Lakehouse.
Built-in machine learning
BigQuery ML provides built-in capabilities to create and run ML models for
your BigQuery data. You can leverage a broad range of models for
predictions, and access the latest Gemini models to derive insights from all
data types and unlock generative AI tasks, such as text summarization, text
generation, multimodal embeddings, and vector search. It increases the
model development speed by directly bringing ML to your data and eliminating
the need to move data from BigQuery.
Built-in data governance
Data governance is built into BigQuery, including full integration of Dataplex
capabilities, such as a unified metadata catalog, data quality, lineage, and
profiling. Customers can use rich AI-driven metadata search and discovery
capabilities for assets, including dataset schemas, notebooks and reports,
public and commercial dataset listings, and more. BigQuery users can also
use governance rules to manage policies on BigQuery object tables.
COMMON USES
Generative AI
Unlock generative AI use cases with BigQuery and Gemini models
Build data pipelines that blend structured data, unstructured data, and generative AI
models together to create a new class of analytical applications. BigQuery integrates
with Gemini 1.0 Pro using Vertex AI. The Gemini 1.0 Pro model is designed for higher
input/output scale and better result quality across a wide range of tasks like text
summarization and sentiment analysis. You can now access it using simple SQL
statements or BigQuery’s embedded DataFrame API from right inside the BigQuery
console.
Data warehouse migration
Migrate data warehouses to BigQuery
Solve for today’s analytics demands and seamlessly scale your business by moving to
Google Cloud’s enterprise data warehouse. Streamline your migration path from
Netezza, Oracle, Redshift, Teradata, or Snowflake to BigQuery using the free and fully
managed BigQuery Migration Service.
Transfer data into BigQuery
Bring any data into BigQuery
Make analytics easier by bringing together data from multiple sources into BigQuery.
You can upload data files from local sources, Google Drive, or Cloud Storage buckets,
use BigQuery Data Transfer Service (DTS), Cloud Data Fusion plugins, replicate data
from relational databases with Datastream for BigQuery, or leverage Google's
industry-leading data integration partnerships.
Unlock value from all data types
Derive insights from images, documents, and audio files and combine
with structured data
Unstructured data represents a large portion of untapped enterprise data. However, it
can be challenging to interpret, making it difficult to extract meaningful insights from it.
Leveraging the power of BigLake, you can derive insights from images, documents,
and audio files using a broad range of AI models, including Vertex
AI’s vision, document processing, and speech-to-text APIs, open-source TensorFlow
Hub models, or your own custom models.
Pre-configured data solutions
Deploy a preconfigured data warehouse in the Google Cloud console
Deploy an example data warehouse solution to explore, analyze, and visualize data
using BigQuery and Looker Studio. Plus, apply generative AI to summarize the results
of the analysis.
Real-time analytics
Event-driven analysis
Gain a competitive advantage by responding to business events in real time with
event-driven analysis. Built-in streaming capabilities automatically ingest streaming
data and make it immediately available to query. This allows you to stay agile and
make business decisions based on the freshest data. Or use Dataflow to enable fast,
simplified streaming data pipelines for a comprehensive solution.
Predictive analytics
Predict business outcomes with leading AI/ML
Predictive analytics can be used to streamline operations, boost revenue, and mitigate
risk. BigQuery ML democratizes the use of ML by empowering data analysts to build
and run models using existing business intelligence tools and spreadsheets.
Predictive analytics can guide business decision-making across the organization.
Log analytics
Analyze log data
Analyze and gain deeper insights into your logging data with BigQuery. You can store,
explore, and run queries on generated data from servers, sensors, and other devices
simply using GoogleSQL. Additionally, you can analyze log data alongside the rest of
your business data for broader analysis all natively within BigQuery.
Learn how to analyze logs using BigQuery
Marketing analytics
Increase marketing ROI and performance with data and AI
Bring the power of Google AI to your marketing data by unifying marketing and
business data sources in BigQuery. Get a holistic view of the business, increase
marketing ROI and performance using more first-party data, and deliver personalized
and targeting marketing at scale with ML/AI built-in. Share insights and performance
with Looker Studio or Connected Sheets.
Explore data and AI solutions built for marketing use cases
Data clean rooms
BigQuery data clean rooms for privacy-centric data sharing
Create a low-trust environment for you and your partners to collaborate without
copying or moving the underlying data right within BigQuery. This allows you to
perform privacy-enhancing transformations in BigQuery SQL interfaces and monitor
usage to detect privacy threats on shared data. Benefit from BigQuery scale without
needing to manage any infrastructure and built-in BI and AI/ML.
FAQ
What makes BigQuery different from other enterprise data
warehouse alternatives?
BigQuery is Google Cloud’s fully managed and completely serverless enterprise data warehouse.
BigQuery supports all data types, works across clouds, and has built-in machine learning and
business intelligence, all within a unified platform.
What is an enterprise data warehouse?
An enterprise data warehouse is a system used for the analysis and reporting of
structured and semi-structured data from multiple sources. Many organizations are
moving from traditional data warehouses that are on-premises to cloud data
warehouses, which provide more cost savings, scalability, and flexibility.
How secure is BigQuery?
BigQuery offers robust security, governance, and reliability controls that offer high availability
and a 99.99% uptime SLA. Your data is protected with encryption by default and customer-
managed encryption keys.
How can I get started with BigQuery?
There are a few ways to get started with BigQuery. New customers get $300 in free credits to
spend on BigQuery. All customers get 10 GB storage and up to 1 TB queries free per month,
not charged against their credits. You can get these credits by signing up for the BigQuery
free trial. Not ready yet? You can use the BigQuery sandbox without a credit card to see how
it works.
What is the BigQuery sandbox?
The BigQuery sandbox lets you try out BigQuery without a credit card. You stay within
BigQuery’s free tier automatically, and you can use the sandbox to run queries and analysis
on public datasets to see how it works. You can also bring your own data into the BigQuery
sandbox for analysis. There is an option to upgrade to the free trial where new customers get
a $300 credit to try BigQuery.
What are the most common ways companies use BigQuery?
Companies of all sizes use BigQuery to consolidate siloed data into one location so you can
perform data analysis and get insights from all of your business data. This allows companies
to make decisions in real time, streamline business reporting, and incorporate machine
learning into data analysis to predict future business opportunities.
