GoogleSQL for Bigtable reference

Preview

This product or feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. Pre-GA products and features are available "as is" and might have limited support. For more information, see the launch stage descriptions.

GoogleSQL for Bigtable is an ANSI compliant Structured Query Language (SQL) that lets you run query statements (also known as Data Query Language (DQL) statements) on Bigtable tables. A query statement scans a table and returns computed result rows.

GoogleSQL for Bigtable doesn't include support for some common SQL constructs, including the following:

• Data Manipulation Language (DML) statements beyond SELECT, such as INSERT, UPDATE, or DELETE
• Data Definition Language (DDL) expressions such as CREATE, ALTER, or DROP
• Data Access Control statements
• Query syntax for subqueries, JOIN, UNION, GROUP BY, UNNEST, and CTEs

For information on where to run SQL queries on your Bigtable data, as well examples of common Bigtable query patterns, see GoogleSQL for Bigtable overview.

What's next

• See all supported functions.
• See all supported operators.
• See all supported conditional expressions.
• Review supported data types.