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: https://developers.google.com/bigquery/
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: https://developers.google.com/bigquery/docs/overview
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:
That’s about it for this post. Thanks Shadab Shah for the questions, I hope this post is useful.
Related articles
- First Impression: Google’s BigData offering called BigQuery (parasdoshi.com)
They were helpful to me too!! Thanks
you’re welcome
thank god i’m connected to your blog 🙂
I am a regular reader of your blog too! 🙂
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: http://googledevelopers.blogspot.com/2012/06/use-google-bigquery-for-your-visual.html
The command line tool and Web UI are extremely powerful, but both are built as client to the API. – Michael Manoochehri
Thanks! updated the post – added them under non browser-based tools.