VentureBeat presents: AI Unleashed - An exclusive executive event for enterprise data leaders. Network and learn with industry peers. Learn More
Google is announcing today that its BigQuery cloud service for running SQL-like queries on data can now easily take in data from the Google Sheets cloud-based spreadsheet software and then save query results inside Google Sheets files.
And changes to spreadsheets won’t cause problems for BigQuery.
“Time after time, we can make changes within our Google Sheets spreadsheet, and BigQuery will automatically pick up the changes next time you run a query against the spreadsheet!” Google BigQuery technical program manager Tino Tereshko wrote in a blog post.
If you’re a power user of Sheets, you’ll probably appreciate the ability to do more fine-grained research with data in your spreadsheets. It’s a sensible enhancement for Google to make, as it unites BigQuery with more of Google’s own existing services. Previously, Google made it possible to analyze Google Analytics data in BigQuery.
An exclusive invite-only evening of insights and networking, designed for senior enterprise executives overseeing data stacks and strategies.
These sorts of integrations could make BigQuery a better choice in the market for cloud-based data warehouses, which is increasingly how Google has positioned BigQuery. Public cloud market leader Amazon Web Services (AWS) has Redshift but no widely used tool for spreadsheets. Microsoft Azure’s SQL Data Warehouse, which has been in preview for several months, does not currently have an official integration with Microsoft Excel, surprising though it may be.
But Google in the past few months has shown signs of caring more about what companies want out of cloud services. In March the company disclosed plans to open data centers in 12 more regions around the world.
In December, Google enhanced BigQuery with custom quotas to limit the amount of money a user spends on any given day.
VentureBeat's mission is to be a digital town square for technical decision-makers to gain knowledge about transformative enterprise technology and transact. Discover our Briefings.