Is BigQuery a database or data warehouse?

Is BigQuery a data warehouse or data lake?

The bottom line is that Google BigQuery is a fully managed serverless data warehouse that enables safe and scalable analysis of petabytes of data.

What type of database is BigQuery?

BigQuery is a business intelligence/OLAP (online analytical processing) system. 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.”

Is Google BigQuery a database?

BigQuery is part of Google Cloud Platform, and integrates with other GCP services and tools. BigQuery can process data stored in other GCP products, including Cloud Storage, the Cloud SQL relational database service, the Cloud Bigtable NoSQL database, Google Drive, and Spanner, Google's distributed database.

Why is BigQuery not a database?

BigQuery is not a transactional database As you can see it takes 1.6 second to run such a simple query on a 88.2 KB table with 481 rows. You need to remember that it's gonna be worst if you access it on NodeJS (2s) or PHP(6s).