Q&A
Ask and answer questions to make information more available to wider audiences.
Karter Anderson
@andersonkarter 31, Mar 2023 12:00 AM
Bigtable vs BigQuery
What is the difference between Bigtable and BigQuery?
answers 1
Answer 1
Jose Grimsbro
@josegrimsbro 03, Apr 2023 04:44 PM
There are 3 critical differences between Bigtable and BigQuery:
1. Bigtable is an OLTP (online transactional processing) system. BigQuery is a business intelligence/OLAP (online analytical processing) system.
2. Bigtable is a NoSQL database service. BigQuery is more of a hybrid; it uses SQL dialects and is based on Google’s internal column-based data processing technology, "Dremel.”
3. Bigtable is mutable and has a fast key-based lookup. BigQuery is immutable and has a slow key-based lookup.