BigQuery is an amazing tool that has simplified my whole workflow
What do you like best?
Having the ability to store and query from extremely large datasets without having to worry so much about infrastructure is amazing. I have databases with trillions of data points in them. Without BigQuery I would need to constantly be upgrading the hardware to store/retrieve the data I need. With BigQuery I only have to worry about making the query optimized to handle the load. The queries are also extremely fast as well as save-able so you can rerun things easily. The web interface and command-line utility are very well documented and easy to use.
What do you dislike?
One gripe I have about BigQuery is the lack of transparency in the error logs. I've run into a couple issues that from the first glance of the error presented was not helpful and actually misleading. Instead, after reaching out to the BQ help, I was able to track it down and mitigate the problem. Besides that, everything has been amazing
What problems are you solving with the product? What benefits have you realized?
Processing billions to trillions of results in the matter of seconds is incredible. Previously, I would need to setup a lot of random sampling and check if the results were converging and I spent more of my time partitioning the data or pruning it down to very small pieces before I could utilize it. With BigQuery, storage and speed are a thing of the past. I no longer have to worry about taking up too much room on our shared devices and I only pay for what I utilize/store.