Hacker News Reader

Comment by makestuff | Hacker News Reader

That always seemed like the long term play to me for GCP. They were beating AWS/Azure on price but it wasn't profitable. All of the companies who signed up for GCP were incredibly short-sighted if they thought those prices would last forever.

What option do you have though? Migrating off of BigQuery would likely take months for any decent sized deployment.

View on HN

Considering GCP is still a distant 3rd, I would have thought they'd aim to get more market share 1st :(

BigQuery was 1 of the main reasons anyone would use GCP.

At my previous job, BigQuery was the only Google Cloud service we used -- everything else was AWS.

Seems similar to ours. We only used bigquery and it seems they are not getting those money.

Does aws not have something similar?

BigQuery is much, much better than Redshift.

Mind you, both of them are worse than Snowflake, but not everyone has a spare child to offer up to get Snowflake discounts ;)

Wouldn't Athena be the service closest to BigQuery?

I don't really know, tbh. I've been at Snowflake shops for a long time now, but from a quick overview it looks like the serverless part is Athena, so like BQ in that sense (and SF also).

But given that Athena uses HiveQL for DDL I'm gonna stand by my original statement.

Yes, Athena is the serverless data querying alternative to BigQuery, not Redshift. When I used Athena for some large scale data querying just a couple years ago it was extremely slow, like two orders of magnitude slower than BigQuery for the same queries. And the UI, documentation, and just general user experience is nowhere near as good as BigQuery's. Nothing from AWS competes with BigQuery, it's genuinely a good product.

There is a Redshift serverless offering now, not sure how it compares though. I think it's not 100% there when it comes to not having to think about the underlying infra yourself...

Redshit Serverless still has a minimum cost. Doesn't scale to 0 or even close.

Not really.

Athena lets you run SQL queries on datasets in S3. You can do something similar in BQ with external tables. BQ is much faster. Athena will easily be more expensive on larger datasets, because you pay $5 per terabyte scanned.

AWS doesn't have a service similar to BQ in terms of performance.

I think the 3 main players in the Analytics space are BQ, Snowflake and Databricks.

Reply on news.ycombinator.com