New Sample Code Available: BigQuery on App Engine

[Andy "Rufus" Rothfusz]

Hello BigQuery Developers!

We thought we'd give you a little present as we head into the winter holiday season: two new code samples using BigQuery on App Engine!

For Java users we have a Google Bigquery App Engine Dashboard Sample which explores almost 137.8 million rows of data about US live births from publicdata:samples.natality.  Every live birth in the US since 1969!  This is a great example of the recommended asynchronous usage of BigQuery queries, authentication using the super-helpful Java OAuth2 library, and even interactive graphs.

For Python users we have the Top 100 SF and Fantasy According to NPR sample which shows BigQuery running on Python App Engine.  The query is a small example of a 3-way JOIN using three small tables (data included!).  You can find the source code in the google-bigquery-tools sample directory under appengine-bq-join.  Like the Java example, this also uses OAuth2 for authentication, but the query is less robust since it uses the synchronous version of BigQuery's query jobs without checking for additional pages of data.

Please comment on this message to let us know what you'd like documented or added to the samples.

Happy Hacking!

/Rufus

Reference URLs: 

http://samples.google-api-java-client.googlecode.com/hg/bigquery-appengine-sample/instructions.html

http://code.google.com/p/google-bigquery-tools/wiki/PythonAppEngineSample

--

Andy "Rufus" Rothfusz | Developer Programs Engineer | GOOGLE | BigQuery