Thursday, January 06, 2011

BigQuery, meet Google Spreadsheets

Since announcing BigQuery at Google IO last May, we’ve been very excited by the response and feedback we’ve received from the developer community, enterprises and academia. The one consistent request we heard from everyone is the ability to interactively analyze large volumes of data without having to worry about provisioning, maintaining and scaling infrastructure.

Today, we would like to announce the integration of BigQuery with Google Apps Script and Google Spreadsheets, a feature we first demoed at Google IO. With this integration users now have the power to query multi-billion row tables, visualize the results and share them with others. Below you can see a simple script that queries a sample dataset and plots the results. A simple tutorial is available here with more to come soon.

We’ve seen a big uptake of the APIs (released in October) which let you create, populate and delete tables in BigQuery. Users have been loading more and more data in BigQuery. For instance the current M-Lab dataset in BigQuery stands at 240B rows!

The details of BigQuery and new features are available on the BigQuery website. We are gradually adding more developers during this free preview period. Please sign up for an invitation, and let us know about the creative and valuable ways you’re using BigQuery.


  1. How I would love to play with this. I've spent the last 5 weeks processing data in a 250 million record mysql database. My cpu has literally been running 24 hours a day for 5 weeks running queries. I can't tell you how sweet it would be to have a bank of servers speed this up.

  2. You can signup for the BigQuery service here.

  3. I have agree with snelson with all best intentions i just cant do without some extra sweet can it bee if google can give us acsess 2 some of their enginess just 4 their use only .. i cant put my things to side just 2 do something 4 google and when i aply 4 job they just take people from CA. America , why they dont open some virtual firms in Europe , specialy in easten Europe where people will brake their back 4 them , 4 less money , they r just plain stupid...