3 ms·
I'd highly recommend anyone who hasn't played with BigQuery yet to take a few moments to give it a shot. I was highly skeptical at first when my old company mov
by wjossey 10y ago
I'd highly recommend anyone who hasn't played with BigQuery yet to take a few moments to give it a shot. I was highly skeptical at first when my old company moved to it, but now I've come to love it as a platform.
What I love most:
[0] Exceptionally fast queries against large datasets.
[1] Very Cost Effective (although as others have called out, it can be accidentally misused resulting in a big bill).
[2] Non data-engineers can setup, use, and manage, with minimal difficulty.
[3] Gets you away from high-priced solutions like Vertica or Teradata.
[4] No management headaches like Redshift.
Downsides:
[0] Quotas can get annoying to work with.
[1] Not a ton of wrappers in a diverse set of languages.
[2] Not a ton of support with desktop SQL clients.
- vgt 10y agoGreat to hear from a happy customer! Some more color commentary: - Quotas can be a little annoying indeed, but they're generally there for a reason. Over time, we've moved BigQuery in direction of having less and less quotas in general - BigQuery recently released ODBC and JDBC drivers, as well as Standard SQL support. so you can plug in your favorite desktop client - On predictability of pricing, there are several flavors of proactive controls - cost per query, cost per user, cost per group, etc. There are reactive billing alerts as well. And as you get to Petabyte scale, there's a flat rate pricing model. (work on GCP)