Google announced a new update to BigQuery today, with the ability to run queries that return large numbers of rows and save them as a new table.
The update also adds window functions, like the ability to take advantage of Rank and Partition to create statistical analyses with simpler SQL. Additionally, recent queries that are re-run return a cached result when the underlying table is unchanged. Google says this provides more cost-effective analysis.
Also included are some new user interface changes, such as the ability to validate a query and estimate its cost before running it, as well as the ability to save frequently used queries. Google has also doubled existing query quotas.
The changes build on other recent features like the ability to connect tools like Tableau, BIME and Excel.
There area also new pricing options, effective in July. Data storage is going from $0.12/GB/month to $0.08/GB/month.
“Furthermore, in addition to the existing on-demand rate for interactive queries, customers with higher-volume usage will soon be able to opt in for tiered query pricing,” says product manager Ju-kay Kwek. “This provides more economical and predictable cost for interactive queries. Customers who are interested are encouraged to contact a sales representative.”
More on the new stuff at Google’s Developers blog.
See how Interactions used BigQuery and Tableau to measure the effects of weather events on retail sales with some research being presented in London today.