Google BigQuery

Skip to the problems!

BigQuery is a serverless, cost-effective and multicloud data warehouse designed to help you turn big data into valuable business insights.

See the official BigQuery site for details and documentation.

Setup

1. Head over to cloud.google.com/bigquery
2. Click "Try BigQuery free" or "Go to console", depending on whether you've already signed up for Google Cloud
3. If you haven't already signed up for Google Cloud Platform, follow the steps to sign up.

Important: You must provide a credit card to use Google Cloud Platform. However, BigQuery has a pretty generous free tier which won't be exceeded by the following practice problems.

Pricing

BigQuery charges for data storage and processing (details). However, it has a generous free tier that lets you store up to 10GB of data and process up to 1TB of data per month. If you exceed these limits, you will be charged (~$0.02 per GB of storage and $0.005 per GB of data processed, as of July 2022).

Next