At a glance
| Data model | Wide-column: row key, column families, timestamped cells |
| Query language | Client library and HBase APIs; GoogleSQL for SELECT only (no DML, joins or subqueries) |
| Consistency model | Strong in a single cluster; eventual by default with replication, configurable per app profile |
| Replication | Add clusters in other zones or regions; replication starts automatically |
| Partitioning or sharding | Automatic, by row key ranges across nodes |
| Transactions | Single-row atomic writes, conditional writes and increments; no multi-row transactions |
| Deployment and cloud availability | Google Cloud only (managed) |
| Licensing | Proprietary service; Enterprise and Enterprise Plus editions |
| Pricing units | Node-hours (per edition) plus storage per GB-month per replica, backups and network |
Bigtable suits teams on Google Cloud with terabytes or more of data read and written by row key at high throughput, such as time series, IoT, ad tech or personalisation data. It is not a general-purpose database: there are no multi-row transactions, SQL is read-only, and you pay for provisioned nodes around the clock, so small or relational workloads belong elsewhere.
Overview
Bigtable is a sparse, sorted key-value map. Each row has a row key and columns grouped into column families; each cell can keep several timestamped versions, and empty columns take no space. Data is stored on Google's Colossus file system rather than on the nodes, so nodes provide compute and can be added or removed (manually or by CPU-based autoscaling) without moving data. Storage can be SSD, HDD or tiered storage (Preview).
An instance with one cluster is strongly consistent. Adding a second cluster starts replication, which is eventually consistent by default and can be configured for read-your-writes or strong consistency through app profiles. Writes to a single row are atomic, and conditional writes and read-modify-write increments are atomic too, but a batch of rows is not. Applications use Google's client libraries, including an extension of the Apache HBase Java client, and GoogleSQL for SELECT queries. Enterprise Plus adds an in-memory tier, larger tiered storage and longer backup retention.
Key features
- Wide-column model with column families and timestamped cell versions, sized for very large single-keyed datasets
- Separation of compute nodes and Colossus storage, with CPU-based autoscaling of nodes
- Multi-cluster replication across zones and regions, with app profiles for routing and consistency
- HBase-compatible Java client plus native client libraries for several languages
- GoogleSQL for SELECT queries, continuous materialized views and logical views
- Data Boost for analytics jobs that do not use the serving nodes, and automated or hot backups
- Enterprise Plus edition: in-memory tier and enhanced tiered storage (Preview), backup retention up to 365 days
Integrations and ecosystem
Pros and cons
Pros
- Built for very large, high-throughput key-based workloads with no servers to manage
- Compute scales independently of storage, including autoscaling
- HBase-compatible client eases migration from Apache HBase
- Replication options up to 99.999% availability, depending on configuration (per Google's editions page)
Cons
- Charged per provisioned node-hour even when idle, so small workloads are costly
- No multi-row transactions and read-only SQL; row key design decides performance
- Google Cloud only
- Several Enterprise Plus features were still in Preview in November 2026
Pricing
Bigtable bills for provisioned compute as node-hours, whether or not the nodes are busy, plus storage per GB-month (SSD, HDD or tiered storage, charged for each replica), backup storage and network transfer. Since April 2026 there are two editions with separate node rates: Enterprise and Enterprise Plus. Google's committed use discount documentation gives an example of USD 0.52 per node-hour in us-central1 after the 20% one-year discount, which corresponds to the USD 0.65 Enterprise node-hour recorded on our Google Cloud overview in October 2026; 3-year commitments save 40%. Commitments cover nodes only, not storage, backups or transfer. We could not read the pricing page itself on 7 November 2026, so confirm Enterprise Plus and storage rates in the console or calculator. There is a 10-day free trial (extendable to 90 days) with a 1-node cluster and up to 500 GB of SSD; Enterprise Plus is not available in the trial.
Pricing checked on the vendor's official page on 7 November 2026. Prices change; confirm before buying.
Who it is best for
Teams on Google Cloud storing terabytes to petabytes of time-series, IoT, financial or user-event data accessed by row key at high throughput.
Typical use cases
- Time-series and IoT telemetry keyed by device and timestamp
- Ad tech, personalisation and recommendation feature stores
- Financial market and transaction history data
- Migrating Apache HBase clusters to a managed service
Who should look elsewhere
- Applications that need relational queries or multi-row ACID transactions: consider Spanner, see our Spanner guide.
- Small or intermittent workloads, where per-node billing outweighs a serverless option such as Firestore: see Google Cloud databases.
Verdict
Bigtable is a mature managed option for very large, key-addressed datasets on Google Cloud, with storage that scales separately from compute. Its node-hour billing, single-row atomicity and read-only SQL make it a specialist store; pick it when throughput and data volume are the problem, and choose Spanner or Firestore when you need transactions or serverless billing.
Frequently asked questions
How is Bigtable priced?
By provisioned node-hours (with separate rates for the Enterprise and Enterprise Plus editions), plus storage per GB-month for each replica, backup storage and network transfer. Committed use discounts of 20% (1 year) and 40% (3 years) apply to nodes only.
Does Bigtable have a free tier?
No permanent free tier. There is a 10-day free trial, extendable to 90 days, with a 1-node cluster and up to 500 GB of SSD storage; Enterprise Plus is not available in the trial.
Can I query Bigtable with SQL?
Yes, for reads. GoogleSQL for Bigtable supports SELECT queries through Bigtable Studio and the executeQuery API in the Java, Python and Go clients, but not DML, DDL, joins, unions, subqueries or CTEs.
Is Bigtable compatible with HBase?
Google provides a supported extension of the Apache HBase Java client, so many HBase applications can connect with limited changes. Check the documented differences before migrating.
Sources
- Bigtable overview (documentation)
- Bigtable editions overview
- Bigtable committed use discounts
- Bigtable writes (atomicity)
- GoogleSQL for Bigtable overview
- Bigtable pricing
Checked November 2026.
Listed in: NoSQL & Distributed Databases.
How we research reviews and what star ratings mean: our editorial method.