https://techcrunch.com/2019/04/10/google-makes-the-power-of-bigquery-available-in-sheets/

Google today announced a new services that makes the power of BigQuery, its analytics data warehouse, available in Sheets, its web-based spreadsheet tool. These so-called ‘connected sheets’ face none of the usual limitations of Google’s regular spreadsheets, meaning there are no row limits, for example. Instead, users can take a massive dataset from BigQuery, with potentially billions of rows, and turn those into a pivot table.

The idea here, is to enable virtually anybody to make use of all of the data that is stored in BigQuery. That’s because from the user’s perspective, this new kind of table is simply a spreadsheet, with all of the usual functionality you’d expect from a spreadsheet. With this, Sheets becomes a frontend for BigQuery — and virtually any business user knows how to use a spreadsheet.