GoogleSQL for Bigtable reference

GoogleSQL for Bigtable is an ANSI compliantStructured QueryLanguage (SQL) that lets you runquerystatements (also known as Data Query Language (DQL) statements) onBigtable tables. A query statement scans a table and returnscomputed result rows.

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

  • Data Manipulation Language (DML) statements beyondSELECT, such asINSERT,UPDATE, orDELETE
  • Data Definition Language (DDL) expressions such asCREATE,ALTER, orDROP
  • Data Access Control statements
  • Query syntax for subqueries,JOIN,UNION, andCTEs

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

What's next

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-12-17 UTC.