Addressing few Q’s a reader had about Google’s BigData offering BigQuery:


After reading First Impression: Google’s BigData offering called BigQuery , a reader (Shadab Shah) had few questions about it and in this blog-post, I am going to address those questions:

Q1. Any browser based Tool’s to Query data in BigQuery?

A1: They have a Browser Based Tool which they call “BigQuery Browser Tool” using which you can Query Data.

Apart from browser based, there are other tools too:

1) a command line tool called “BQ command-line tool. You can find more information here:

2) API. one can “include” big data analytic capabilities into a web app via RESTFul API. (Point #2 content credit: Michael Manoochehri’s comment)

Q2) Where is the Data Stored? 

If i just say “Google Cloud” that would not be a complete answer. There’s a complementary service called “Google CLOUD SQL” and so I do not want you to confuse data stored for BigQuery with “Google cloud SQL”.Theres’ a difference between BigQuery and Google cloud SQL, you can read that here:

Having said that, it’s stored on Google’s cloud and if you wish to use BigQuery – you’ll have to upload your data-set in a CSV format and if you do so, it’s stored in Google cloud and is ready to be analyzed via BigQuery.

Q3) Where do I find lots of data to play with BigQuery?

Google has few sample data-sets that you can play with:

bigquery sample data

That’s about it for this post. Thanks Shadab Shah for the questions, I hope this post is useful.

8 thoughts on “Addressing few Q’s a reader had about Google’s BigData offering BigQuery:

  1. manoochehrigoogle

    You missed the most important “tool” for querying data – the API. The biggest value add for Google BigQuery is that it is designed from the ground up as a developer tool – the power to incorporate massive structured data analytics via RESTful API into existing web applications is quite novel. Examples:

    The command line tool and Web UI are extremely powerful, but both are built as client to the API. – Michael Manoochehri

What do you think? Leave a comment below.