We are excited to bring Transform 2022 back in-person July 19 and virtually July 20 - 28. Join AI and data leaders for insightful talks and exciting networking opportunities. Register today!

Google today is announcing the launch of new features for its BigQuery cloud data warehouse service.

Since BigQuery became available to all developers in 2012, it’s been possible to query data with the SQL-like BQL, which stands for BigQuery Query Language. Now Google is bringing full SQL to the service, and that’s significant because of the pervasiveness of ANSI SQL, which is the lingua franca for data analysts.

Now people can use theta joins in BigQuery, and dates, times, arrays, and timestamps are now supported, Google technical lead and manager Dan Delorey and technical product marketing manager Bosco Zubiaga wrote in a blog post. Analysts can also submit more detailed subqueries within any part of a query, wrote Delorey and Zubiaga.

Google is also bringing the Cloud identity and access management (IAM) feature of Google Cloud Platform to BigQuery.


Transform 2022

Join us at the leading event on applied AI for enterprise business and technology decision makers in-person July 19 and virtually from July 20-28.

Register Here

And now analysts have a way to get better performance by limiting queries to certain time periods. The feature can be viewed as an answer to the Table Partitioning feature of Microsoft’s SQL Server database software.

But more generally, these additions make BigQuery a slightly better choice as a standalone querying service. Clearly, Google is trying to make the service more competitive with the Redshift service from Amazon Web Services (AWS), which is considerably farther ahead of the Google Cloud Platform in the public cloud market. Other services in this category include Microsoft’s Azure SQL Data Warehouse and Snowflake.

In recent months, Google has fleshed out BigQuery with custom quotas and an integration with Google Sheets.

VentureBeat's mission is to be a digital town square for technical decision-makers to gain knowledge about transformative enterprise technology and transact. Learn more about membership.