BigQuery documentation
BigQuery is Google Cloud's fully managed, petabyte-scale, and cost-effective analytics data warehouse that lets you run analytics over vast amounts of data in near real time. With BigQuery, there's no infrastructure to set up or manage, letting you focus on finding meaningful insights using GoogleSQL and taking advantage of flexible pricing models across on-demand and flat-rate options. Learn more
Start your next project with $300 in free credit
Build and test a proof of concept with the free trial credits and free monthly usage of 20+ products.
Documentation resources
Guides
-
Quickstarts: Console, Command line, or Client libraries
-
Creating and using tables
-
Introduction to partitioned tables
-
Introduction to BigQuery ML
-
Predefined roles and permissions
-
Introduction to loading data
-
Loading CSV data from Cloud Storage
-
Exporting table data
-
Create machine learning models in BigQuery ML
-
Querying external data sources
Reference
-
Functions in GoogleSQL
-
Operators in GoogleSQL
-
Conditional expressions in GoogleSQL
-
Date functions in GoogleSQL
-
Query syntax in GoogleSQL
-
String functions in GoogleSQL
-
Using the bq command-line tool
-
End-to-end journey for machine learning models
-
BigQuery API Client Libraries
-
Creating and training models
Related resources
Related videos
Migrating App Engine pull tasks to Cloud Pub/Sub (Module 19)
Serverless Migration Station is a Serverless Expeditions mini-series focused on helping developers modernize their applications running on a Google Cloud serverless compute platform. In Module 19, the second video focused on App Engine pull tasks,
How to use App Engine Task Queue pull tasks (Module 18)
Serverless Migration Station is a Serverless Expeditions mini-series focused on helping developers modernize their applications running on a Google Cloud serverless compute platform. In Module 18, Google engineers Martin & Wesley show viewers how
Refactoring a Python 2 Cloud NDB app to Python 3 & Cloud Firestore (Module 9)
Module 9 resources: Codelab → https://goo.gle/3pYGwzA Python 2 START ("mod8") code → https://goo.gle/3j3TyYa Python 3 FINISH ("mod9") code → https://goo.gle/3BCemfZ Serverless Migration Station is a Serverless Expeditions mini-series, designed to
Migrating App Engine push queues to Cloud Tasks (Module 8)
Module 8 references: Codelab → https://goo.gle/3lJMtxF Python 2 START ("mod7") code → https://goo.gle/3kEvtsl Python 2 FINISH ("mod8") code → https://goo.gle/3j3TyYa Serverless Migration Station is a Serverless Expeditions mini-series, designed to
How to use App Engine push queues in Flask apps
Codelab → https://goo.gle/3hYdmf2 Python 2 START ("mod1") code → https://goo.gle/3xfynHx Python 2 FINISH ("mod7") code → https://goo.gle/3kEvtsl Serverless Migration Station is a Serverless Expeditions mini-series focused on helping developers
Pub/Sub tips and tricks
Dead-letter queues → http://goo.gle/3u5dLkl Message ordering → http://goo.gle/2M5CaVK Replaying past messages → http://goo.gle/3du08oP Pub/Sub is an asynchronous messaging service that can help you easily run serverless applications. However, there
Task Queues, Stackdriver, & more!
Here to bring you the latest news in the cloud is Google Cloud Developer Advocate Mark Mirchandani. Learn more about these announcements → https://bit.ly/2IOikem • Queued Up → https://bit.ly/2PzLTRC • Big Data, Big Updates → https://bit.ly/2PytVyB •
Messaging on the Cloud: GCPPodcast 7
Original post: https://www.gcppodcast.com/post/episode-7-messaging-on-the-cloud/ In the seventh episode of this podcast, your hosts Francesc and Mark discuss the different ways messaging can be done on Google Cloud Platform, covering Pub/Sub and Task
Try BigQuery for yourself
Create an account to evaluate how our products perform in real-world
scenarios.
New customers also get $300 in free credits to run, test,
and deploy workloads.