Is BigQuery a SQL or NoSQL?

Question

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.” Bigtable is mutable and has a fast key-based lookup.

Is BigQuery a NoSQL?

BigQuery is a hybrid system that allows you to store data in columns, but it takes into the NoSQL world with additional features, like the record type, and the nested feature.

Does BigQuery use SQL?

BigQuery supports two SQL dialects: standard SQL and legacy SQL.

Is BigQuery just SQL?

BigQuery is a REST-based web service which allows you to run complex analytical SQL-based queries under large sets of data.

What type of SQL is BigQuery?

BigQuery supports the Google Standard SQL dialect, but a legacy SQL dialect is also available. If you are new to BigQuery, you should use Google Standard SQL as it supports the broadest range of functionality. For example, features such as DDL and DML statements are only supported using Google Standard SQL.

Expert · Answer