Stay organized with collections
Save and categorize content based on your preferences.
Introduction to SQL in Bigtable
In addition to its Admin and Data APIs, Bigtable supports SQL queries.
You can use SQL to query your Bigtable data in the following
ways:
For low-latency application development, GoogleSQL for
Bigtable
For batch processing and ETL, Spark SQL
To analyze data from multiple sources, BigQuery
GoogleSQL for Bigtable
GoogleSQL is a query language used by multiple Google Cloud
services, including Spanner and BigQuery. You can create and run GoogleSQL queries in Bigtable Studio in
the Google Cloud console, or you can run them programmatically using the
Bigtable client library for Java.
GoogleSQL for Bigtable is similar to the Cassandra
query Language (CQL) in many ways, and it includes a map data type, designed to
query the Bigtable data stored in column families, columns, and
cells.
For data science use cases or other batch processing and ETL, the
Bigtable Spark connector lets you read and write
Bigtable data using Spark SQL. For more information, see
Use the Bigtable Spark connector.
BigQuery
If you want to blend data from multiple sources, including
Bigtable, and run batch, ad hoc analytics, you can create
BigQuery external tables and run SQL queries from
BigQuery. For more information, see
Query and analyze Bigtable data with BigQuery.
[[["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-03-05 UTC."],[[["Bigtable supports SQL queries through multiple methods, including GoogleSQL for low-latency applications, Spark SQL for batch processing and ETL, and BigQuery for analyzing data from multiple sources."],["GoogleSQL for Bigtable, which is similar to Cassandra Query Language (CQL), can be used within the Google Cloud console via Bigtable Studio, or programmatically through the Bigtable client library for Java."],["The Bigtable Spark connector enables reading and writing Bigtable data with Spark SQL, beneficial for data science and batch processing needs."],["BigQuery can query and analyze data from Bigtable alongside other sources using external tables, facilitating batch and ad hoc analytics."]]],[]]
