Google Cloud Platform for Architects

When to use Bigtable

Avoid Bigtable under the following set of circumstances:

• Do not use Bigtable if you require transaction support because, as we have already discussed, Bigtable will only offer row-level ACID guarantees and that is just not enough. Use Cloud SQL or Cloud Spanner if you need to carry out OLTP.
• Do not use Bigtable if your data size is going to be less than 1 TB. That's because Bigtable needs to do a set of smart optimizations related to sharding and distributed storage, and you just won't be able to do that if your dataset is too small.
• Do not use Bigtable if you plan to use Analytics, Business Intelligence, or data warehousing use cases. BigQuery is a better option as BigQuery supports an SQL-like interface that many data ...