For side projects and such I use Metabase[2] which is open source and pretty useful for giving business users access to query data. Its visualizations are rudimentary but workable.
Caravel in particular has some great exploration tools. You can build queries either by hand or by using visualization specific drag and drop. Caravel is getting regular updates from the AirBnB team too.
If you want more power I recommend using a Jupyter notebook and Python. There's also Rodeo which is like R Studio for Python.
Wow, now I know that's just anecdotal, but that feels about right, and very interesting to have written down. Thanks for that, it's good food for thought.
(Now I'm just wondering what the last 10% is... ;) )
Box sales was super responsive, and even got me on the phone to chat with their engineering team about our needs.
Dropbox was completely unresponsive.
Would love for you to replicate Wagon :)
I'd be happy to pay $5-10 / month to continue to use Wagon past October
There is a simple question to determine your relationship to a company or product, are you the customer or the product. Did you pay for it?
If no, you're the product and they can arbitrarily change the rules of the game.
If yes, yay you.
EDIT: Their Twitter account also gives a little bit of information: Wagon is a modern SQL editor. A better way for analysts and engineers to write queries, visualize results, and share data & charts [4].
[1] https://www.wagonhq.com/about
[2] https://www.wagonhq.com/blog/engineering-at-wagon/
This was inevitable, though - the Wagon team didn't seem too concerned about trying to find a way to monetize the app.
For me, that was very short lived, but their application did actually seem nice. What a bummer.