Run a query (dataset: samples, table: shakespeare, substring: raisin)
Run a query (dataset: samples, table: shakespeare, substring: huzzah)
Create a new dataset (name: babynames)
Load the data into a new table
Run queries against your dataset table
Remove the babynames dataset
BigQuery: Qwik Start - Command Line
Storing and querying massive datasets can be time consuming and expensive without the right hardware and infrastructure. BigQuery is a serverless, highly scalable cloud data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google's infrastructure. Simply move your data into BigQuery and let us handle the hard work. You can control access to both the project and your data based on your business needs, such as giving others the ability to view or query your data.
You can access BigQuery by using the Console, Web UI or a command-line tool using a variety of client libraries such as Java, .NET, or Python. There are also a variety of solution providers that you can use to interact with BigQuery.
This hands-on lab shows you how to use
bq, the python-based command line tool for BigQuery, to query public tables and load sample data into BigQuery.
Join Qwiklabs to read the rest of this lab...and more!
- Get temporary access to the Google Cloud Console.
- Over 200 labs from beginner to advanced levels.
- Bite-sized so you can learn at your own pace.