UPDATED 06:00 EDT / AUGUST 30 2012

NEWS

BigQuery Gets Bigger and Better with Batch Processing and Excel Integration

Google’s BigQuery has just received a major new update with not one, but two new features that add more functionality to the popular data set analysis tool.

The updates include a new batch-processing feature that allows users to schedule queries that are less time-sensitive, while the tool can now be integrated with Microsoft Excel.

BigQuery has proved to be a massive hit among businesses since its launch in May. The cloud-based service offers an efficient platform for running SQL queries against massive data sets, delivering the answers you need within seconds. However, one of the few frustrations users expressed about the software was that all queries had to be performed manually.

Ju-Kay Kwek, BigQuery’s Product Manager, wrote in a blog post:

“We understand that there are important, non-interactive queries, such as nightly reports, that businesses also need to run. Now, you can designate a query as a batch query and it will complete within a few hours.”

As well as being more convenient in some instances, the slowed down queries are also cheaper – available for the price of just 2 cents a gigabyte, rather than the standard 3.5 cents for real-time queries.

Google has also responded to users by making integration with Excel possible. The company noted that Microsoft’s spreadsheet program is still the most popular tool for those working with data, and perhaps also realized that those products that acknowledge this tend to be much more popular than those that force people to use tools they’re unfamiliar with.

These updates are yet more evidence that Google is determined to advance its suite of enterprise tools and embrace the big data opportunity.


Since you’re here …

… We’d like to tell you about our mission and how you can help us fulfill it. SiliconANGLE Media Inc.’s business model is based on the intrinsic value of the content, not advertising. Unlike many online publications, we don’t have a paywall or run banner advertising, because we want to keep our journalism open, without influence or the need to chase traffic.The journalism, reporting and commentary on SiliconANGLE — along with live, unscripted video from our Silicon Valley studio and globe-trotting video teams at theCUBE — take a lot of hard work, time and money. Keeping the quality high requires the support of sponsors who are aligned with our vision of ad-free journalism content.

If you like the reporting, video interviews and other ad-free content here, please take a moment to check out a sample of the video content supported by our sponsors, tweet your support, and keep coming back to SiliconANGLE.