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
[ Parent
| on HN ]
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.