Re:Google makes BigQuery available in Sheets
by lukasb on Friday April 12, 2019 @04:33AM
(#19643080)
BigQuery is usually intended for data warehouse use cases, where missing the most recent 23 hours of data is less of a big deal. It's intended to feed things like exec dashboards, not production systems.
[ Parent
| on HN ]
Re:Google makes BigQuery available in Sheets
by hulahoof on Friday April 12, 2019 @05:33AM
(#19643374)
I believe the views will refresh when the underlying data changes, so if you are streaming or inserting frequently the costs could add up
Re:Google makes BigQuery available in Sheets
by SmirkingRevenge on Friday April 12, 2019 @08:10AM
(#19644055)
Big query isn't a great use case if data that needs to be queried repeatedly and is updating that frequently, I don't think. With streaming inserts, you probably should generally only be doing inserts on the latest date/time based partition, so that you can take advantage of cached queries for all data but the most recent date/time partition.