Subsection 2.1

What is BigQuery

~3 min

Reading

BigQuery is a Google Cloud service that stores data and lets you query it with SQL.

Try this analogy

Think of BigQuery as a shared community pantry

A community pantry sits in one location, but multiple organizations can access it, contribute to it, and take what they need. The pantry is maintained by someone else : you don't have to worry about who restocks it or fixes the shelves. You just walk in, find the section you need, and take what's there.

BigQuery is like that pantry, but for data. Google maintains the infrastructure (the building, the shelves, the lights). Your team contributes tables or reads from existing ones. Multiple teammates can use it at the same time without bumping into each other. You don't install anything, set up servers, or buy hardware. You sign in, find your shelf, and get to work.

You do not need to install anything. You open BigQuery in a browser, sign into Google Cloud, point at a dataset, and write SQL in the editor. For the activities in this course, the free sandbox tier is enough.

BigQuery is a fully managed, serverless data warehouse. "Serverless" does not mean there are no servers. It means you do not manage the servers yourself. You focus on the data and the query. Google Cloud handles the infrastructure behind the scenes.

BigQuery can handle very large datasets, including petabyte-scale data. It can start small and scale as your needs grow. It is part of Google Cloud Platform, so it can connect with other Google tools and cloud services.

For organizing and civic tech work, BigQuery can help when teams need to bring together large tables, run repeatable reports, or prepare data for dashboards. For example, a team might combine community needs surveys with notes from intake conversations, then use that structured information to improve outreach or case triage.

Why BigQuery for this course?

It runs in a browser.
It supports SQL-like queries.
It has public datasets.
It includes schema, preview, results, and query writing in one interface.
It can connect to tools like Google Sheets, Looker Studio, Tableau, and Colab.

Learner action

Open console.cloud.google.com/bigquery in a new tab. Sign in with a Google account. If this is your first time, accept the BigQuery sandbox terms. For this course, you do not need to add billing.

BigQuery is a Google Cloud service that stores data and lets you query it with SQL. You do not need to install anything. You open it in a browser, point at a dataset, and write SQL in the editor. The free sandbox tier is more than enough for this course.

Why BigQuery for this course?

Free sandbox tier with no billing required for the activities we do.
A library of public datasets (bigquery-public-data) covers everything from census data to political ads to air quality.
The interface is friendly to first-time SQL users : schema, preview, and run all live on one screen.

Diagram 2.1 · Path to BigQuery. Sign into Google Cloud in any browser; the BigQuery console gives you datasets, tables, and a query editor on one page.

Open BigQuery now

Open console.cloud.google.com/bigquery in a new tab. Sign in with a Google account. If this is your first time, accept the BigQuery sandbox terms : you do not need to add a credit card.

BigQuery is a place to store and query tables exactly like the one you've been previewing. Here's a query that pulls voters from one specific county : try running it, then change the county to DeKalb.

Action: Open BigQuery in a new tab. Keep this lesson open in another tab.

Slide to complete