Google BigQuery Bringing Simplicity to Large Data Analytics in the Cloud Using SQL

Google BigQuery gets updates giving BigQuery a greater range of query and data types, more flexibility with table structure, and better tools for collaborative analysis. Google buys Talaria as part of Google Cloud Platform.

Some more new capabilities added to Google BigQuery that will give businesses new ways to work effectively with large amounts of data.

In a blog post annoucing the features, Google says these capabilities, "will now let you join and perform aggregate analysis on multi-terabyte datasets using SQL-like queries or integrated 3rd party tools, instead of having to initiate complex coding projects."

Today with BigQuery you can get directly to business insights using SQL-like queries, with far less effort and far greater speed than you could before.

"Joining terabyte-sized tables has traditionally been a challenging task for data analysts, requiring sophisticated MapReduce development skills, powerful hardware, or a lot of time--often all three," Google adds.

Further Google notes that it has been using this technology within Google--explaining, that "when our App Engine team needed to reconcile app billing and usage information, Big JOIN allowed the team to merge 2TB of usage data with 10GB of configuration data in 60 seconds. Big Group Aggregations enabled them to immediately segment those results by customer. Using the integrated Tableau client the team was able to quickly visualize and detect some unexpected trends," Google said.

Here is what is news:

  • "Big JOIN: use SQL-like queries to join very large datasets at interactive speeds
  • Big Group Aggregations: perform groupings on large numbers of distinct values
  • Timestamp: native support for importing and querying Timestamp data."

Pricing remains the same "you pay only for the actual data that's processed by your queries."

Google BigQuery Web UI: Dataset links and dataset sharing notifications

Update 03/16: Google has acquired Talaria, a company that was building a "new, dynamic web application server with a JIT-based runtime at its heart."

A Google spokesperson confirmed the acquisition stating,

"The Talaria team has developed cutting-edge technology that helps people build and run websites more efficiently, and we think they'll be a great addition to our Google Cloud Platforms team."