Google Bigtable vs BigQuery for storing large number of events

FYI

Cloud Bigtable is not a relational database; it does not support SQL queries or joins, nor does it support multi-row transactions. Also, it is not a good solution for small amounts of data (< 1 TB).

Consider these cases: - If you need full SQL support for an online transaction processing (OLTP) system, consider Google Cloud SQL.

If you need interactive querying in an online analytical processing (OLAP) system, consider Google BigQuery.

If you need to store immutable blobs larger than 10 MB, such as large images or movies, consider Google Cloud Storage.

If you need to store highly structured objects, or if you require support for ACID transactions and SQL-like queries, consider Cloud Datastore.

Bigtable is great for large (>= 1TB) mutable data sets. It has low latency under load and is managed by Google. In your case, I think you're on the right track with BigQuery.