In this course you will learn what Google's cloud offering for querying massive datasets by using a SQL-like language is. You will learn the capacities of the offering, i.e. what types of query workloads you can execute and costs. You will learn what aspects of SQL language are supported, how to query via the API and more.
Using BigQuery An interesting aspect of a BigQuery service is that many large vendors of data visualization have announced integration with BigQuery, which to me is a very important endorsement of the underlying technology and the service offering. And of those, I have taken a look at the QlikView, Tableau, Excel 2010, Google spreadsheets, and BIME, I think its pronounced BIME implementations. It's very interesting to see how the connectors function and what type of visualizations that will be available for end users with BigQuery. In this demo, I'm going to show a couple of the third-party integration connectors and the results of the integration with BigQuery.
Using BigQuery API in Java Now we're ready to get started with BigQuery programming in Java for your particular application. Google has a number of samples that they have made available in the various programming languages including Java so we'll be working through their samples. As mentioned previously, I recommend that you will be working with an editor. I'll be using Eclipse. And if you are using Eclipse I recommend that you get the Google app engine software development kit, and the Google app engine plugin for Eclipse which includes a very easy way for you to just basically click and pull in the APIs for BigQuery. ( Pause ) This is a screen shot of just how easy that is. Once you create a type of project inside of Eclipse, then you can just right click and say add Google managed APIs and simply pull in the BigQuery API. Of course, there are many other ways to do this, but as mentioned in the beginning of this course I'm trying to give you the simplest on ramp so that you can get up and going quickly and easily programmatically accessing BigQuery. So in this demo I'm going to show you how to programmatically access BigQuery API in Java.