Stay organized with collections Save and categorize content based on your preferences.
GoogleSQL for Bigtable reference
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, 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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-04-29 UTC."],[[["GoogleSQL for Bigtable allows running query statements on Bigtable tables, returning computed result rows."],["It is an ANSI-compliant SQL but only supports `SELECT` statements, and does not include DML statements like `INSERT`, `UPDATE`, or `DELETE`."],["Features like DDL expressions, Data Access Control, and query syntax for subqueries, `JOIN`, `UNION`, `GROUP BY`, `UNNEST`, and `CTEs` are unsupported in GoogleSQL for Bigtable."],["This product is currently in a pre-GA stage, meaning it is available \"as is\" with potentially limited support."]]],[]]
