About Google BigQuery
BigQuery is Google Cloud's serverless data warehouse for running SQL on very large datasets. It also includes machine learning and AI features that work on the same data.
What it does
BigQuery stores tables and runs analytical SQL without you managing servers. You load data, query it and share results across your organization. Models can be trained and run with SQL, and AI functions can handle text tasks such as summarization and sentiment analysis inside a query. The service also supports vector and text search, which helps with retrieval for AI applications, and graph queries over relationship data.
Key features
- Serverless SQL queries over large tables
- Train and run machine learning models with SQL
- AI functions for text tasks inside queries
- Vector, text and hybrid search
- Graph queries over relationship data
Who it's for
Data analysts, data engineers and companies that want one platform for warehousing, machine learning and AI. It suits teams that already work within Google Cloud.
Pricing and good to know
The site lists a free tier with 10 GiB of storage and up to 1 TiB of queries each month. New customers also receive $300 in free credits for BigQuery and other Google Cloud products. Usage beyond the free tier is billed, so keep an eye on query size and scanned data to control costs.
Highlights
- Run SQL on very large tables without managing servers
- Train and run machine learning models with SQL
- Summarize or classify text inside a query
- Search by meaning, keywords or both
- Query relationships with graph syntax
