3 ms·
BigQuery is one of the few products that truly feels magical. It lives up to the "no-ops" model of just working without thinking about details and handles any s
by manigandham 9y ago
BigQuery is one of the few products that truly feels magical. It lives up to the "no-ops" model of just working without thinking about details and handles any scale of data you have.
Only downsides would be cost-per-run pricing and low-latency queries.
- jmelloy 9y agoI agree. The performance you get for the cost and effort is amazing.
- ccmonnett 9y agoThere are several other "no-ops" services that Google offers in GCP that we leverage to great effect (and personally, as the guy who would be doing the "ops" part, really enjoy using). It's quite liberating to be able to use a powerful product with _literally_ zero operations 'cost' in terms of mindshare - not getting sucked backwards to upgrade/fix/whatever service we're using, reliably, reduces a lot of mental burden and makes it easier to keep moving forwards.
- timc3 9y agoWhich ones are you thinking about in particular?
- JPKab 9y agoAgreed. One point that this article doesn't address (not that it necessarily SHOULD) is the fact that BigQuery achieves these results with zero database administration or schema design. Redshift is great, but it's not "set and forget". Also, there are a huge number of use cases out there which are daily reports on large datasets. Fixed vs. Variable cost models are obviously going to shift in favor of variable when this kind of scenario comes into play. Last, what kind of cost factor do you think comes into account when it comes to paying someone to administer your Redshift db, vs not paying anyone to administer the BigQuery setup. I can tell you from experience that this is a huge, huge factor.
- mattbillenstein 9y agoI think you need someone to run and optimize the data warehouse in any case -- figuring out data exports to BQ, table partitioning, etc don't really come for free. Perhaps BQ is easier in that you don't have to figure out how to run and scale a Redshift cluster, but as a BQ user, I do a decent amount of work mucking around with the schemas and figuring out how to do things more performantly or cheaply.