Google Bigtable is Google Cloud’s NoSQL database that was introduced in 2015 and now boasts a large customer base. It has also served as an inspiration for other open-source databases like HBase and Cassandra.
Recently, Google has enhanced Bigtable to support queries using GoogleSQL, which is a version of SQL used in other services such as BigQuery and Cloud Spanner. This allows users to query data from Bigtable using familiar SQL language (GoogleSQL is compatible with the widely used ANSI SQL).
Some may wonder how SQL can communicate with a NoSQL database, given their different architectures. The answer lies in Google’s approach of mapping table column groups to SQL data types and adding commonly used features like extracting data as JSON and storing time-series data.
The SQL features are now available in the SQL editor of Bigtable Studio.
TLDR: Google Bigtable, a NoSQL database by Google Cloud, now supports queries using GoogleSQL, allowing users to query data using SQL language.
Leave a Comment