3 ms·
Just accidentally spent $300 on a single BigQuery query AMA
- dusted 4y ago56,806,941 rows... inner-joined on a table of 15,284,829 rows... with multiple calls to PERCENTILE_CONT That's peanut data, why in the world does that cost anything but a few cents in electricity? Cloud stuff reminds me of the dark-ages of my teenage years when every single SMS would cost money :D
- AVDAMS 4y agoHi the same thing did happen to me a few weeks ago and not for the first time. I decide to migrate over the ClickHouse after reading this blog: https://clickhouse.com/blog/hifis-migration-from-bigquery-to-clickhouse https://clickhouse.com/blog/hifis-migration-from-bigquery-to... Took me less than two weeks to completely migrate over. It saves costs but more important I did gain performance!