Introduction to Google's BigQuery

BigQuery

A BigQuery is a web-based tool that allows us to execute SQL-like queries and enables interactive analysis of massively large datasets at outstanding speeds working in conjunction with Google Storage.

BigQuery pricing

Charges are rounded to the nearest MB, with a minimum 10 MB data processed per table referenced by the query. The first 1 TB of data processed per month is free of charge. Other operations, such as saving a table to the cloud, requires you to set up billing. Setting up billing requires a cost ($0.026 per GB, per month) and for small queries, you won't need it.

Setting Up BigQuery

For setting up a BigQuery obviously you need a Google account. We can start a sample project by going through Google API Consloe.

Procedure

Step 1

After signing into the Google API Console, click on Create Project. Provide a name for your project. At this step the project will be created.



Step 2

A Dashboard will appear, click on Try BigQuery that will be in the top-left corner.



Step 3

After clicking on Try BigQuery a page will appear where you have some data to query. Click on Compose Query to query with sample data.



Getting Data for BigQuery

There are 2 ways to do this, either query sample data or load your own data.