What do you like best?
The fact that I can store millions of records without it costing me a fortune. I like their web interface which allows me to look through my data and run queries on it from anywhere. I like that I can set everything up through the web interface.
It's also very easy to add more columns to data even after existing data is in place.
What do you dislike?
I'm not a big fan of Google Cloud Platform's support model. The cheapest option available is $150/month, which for a small business like ours almost doubles our monthly bill.
Other than that, I don't really have any complaints, but the only thing that comes to mind is that the client libraries are quite large.
Recommendations to others considering the product
BigQuery is easy to use and can handle a large amount of data before it starts costing you anything. Because of this, it's easy to evaluate how well it works for your needs before having to start paying.
They also have several large data sets that can be played with to learn your way around and get started including all of the source code on GitHub.
What business problems are you solving with the product? What benefits have you realized?
We needed to store large amounts of data for analytics purposes and BigQuery has allowed us to do that easily and without adding a lot of cost.
We've been able to start storing all of this analytics data and once we have enough to be useful I don't expect us to have a difficult time using it.