Providing tips on running complex queries and writing code to communicate with the BigQuery API, this guide comes from Jordan Tigani and Siddartha Naidu, founding members of the Google BigQuery team. They explain and demonstrate streaming ingestion, transformation via Hadoop in Google Compute engine, AppEngine datastore integration and how to use GViz with Tableau to generate charts of query results, using real-world examples.