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-08-07 UTC."],[[["\u003cp\u003eGoogleSQL for Bigtable allows running query statements on Bigtable tables, returning computed result rows.\u003c/p\u003e\n"],["\u003cp\u003eIt is an ANSI-compliant SQL but only supports \u003ccode\u003eSELECT\u003c/code\u003e statements, and does not include DML statements like \u003ccode\u003eINSERT\u003c/code\u003e, \u003ccode\u003eUPDATE\u003c/code\u003e, or \u003ccode\u003eDELETE\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eFeatures like DDL expressions, Data Access Control, and query syntax for subqueries, \u003ccode\u003eJOIN\u003c/code\u003e, \u003ccode\u003eUNION\u003c/code\u003e, \u003ccode\u003eGROUP BY\u003c/code\u003e, \u003ccode\u003eUNNEST\u003c/code\u003e, and \u003ccode\u003eCTEs\u003c/code\u003e are unsupported in GoogleSQL for Bigtable.\u003c/p\u003e\n"],["\u003cp\u003eThis product is currently in a pre-GA stage, meaning it is available "as is" with potentially limited support.\u003c/p\u003e\n"]]],[],null,[]]
