NoSQL: BigQuery stores table data in columnar format, meaning it stores each column separately. Column-oriented databases are particularly efficient at scanning individual columns over an entire dataset. source
SQL: BigQuery is an enterprise data warehouse for large amounts of relational structured data source