Using Google's Cloud For Developers - Google BigQuery

In this course you will learn what Google's cloud offering for querying massive datasets by using a SQL-like language is.
Course info
Rating
(45)
Level
Intermediate
Updated
Mar 29, 2013
Duration
2h 25m
Table of contents
Description
Course info
Rating
(45)
Level
Intermediate
Updated
Mar 29, 2013
Duration
2h 25m
Description

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.

About the author
About the author

Lynn Langit has been working with data for over 14 years. She is an architect, author and popular speaker on SQL Server, Google Cloud, Hadoop, MongoDB and more.

More from the author
Teaching Kids Programming with C#
Beginner
1h 14m
Mar 25, 2013
Introduction to Google Cloud
Beginner
52m
Jan 10, 2013
Section Introduction Transcripts
Section Introduction Transcripts

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.