News for hackers. Stuff that matters.

A comment on Google makes BigQuery available in Sheets. Parent comment

Re:Google makes BigQuery available in Sheets by havermeyer on Friday April 12, 2019 @12:35PM (#19646374)
Give BI Engine a try! https://cloud.google.com/bi-engine/docs/. The model is that you pay for storage--currently free during the beta--but any queries from Data Studio don't incur costs. It was just announced during Next this week.

As a disclaimer, I'm an engineer on the BigQuery team (but not BI Engine specifically).

[ Parent | on HN ]
Re:Google makes BigQuery available in Sheets by polskibus on Friday April 12, 2019 @02:44PM (#19647810)
what happens if the data in bigquery changes, for example a row inserted? Are there any additional costs related to invalidation of the in-memory cache (ie the BI Engine) ?
[ Parent | on HN ]
Re:Google makes BigQuery available in Sheets by havermeyer on Friday April 12, 2019 @04:19PM (#19648593)
Tables created in projects that have BI Engine enabled support streaming inserts, DML operations, etc. just like other BigQuery tables. Any queries you run using BigQuery itself incur regular query costs (https://cloud.google.com/bigquery/pricing#queries) but there are no extra charges beyond the storage costs (https://cloud.google.com/bi-engine/pricing) for BI Engine to manage the data for you behind the scenes.
[ Parent | on HN ]