TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Just accidentally spent $300 on a single BigQuery query AMA

4 pointsby tapanjkabout 2 years ago

2 comments

dustedabout 2 years ago
56,806,941 rows...<p>inner-joined on a table of 15,284,829 rows...<p>with multiple calls to PERCENTILE_CONT<p>That&#x27;s peanut data, why in the world does that cost anything but a few cents in electricity?<p>Cloud stuff reminds me of the dark-ages of my teenage years when every single SMS would cost money :D
AVDAMSabout 2 years ago
Hi 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: <a href="https:&#x2F;&#x2F;clickhouse.com&#x2F;blog&#x2F;hifis-migration-from-bigquery-to-clickhouse" rel="nofollow">https:&#x2F;&#x2F;clickhouse.com&#x2F;blog&#x2F;hifis-migration-from-bigquery-to...</a> Took me less than two weeks to completely migrate over. It saves costs but more important I did gain performance!