We used both, and ended up going with Superset for internal dashboards and data exploration. Redash is more polished to look at, but Superset offers more functionality. However, some things are still rough around the edges; I get occasional 500's during normal navigation, and the filtering options are immature, using only "IN" or "NOT IN" (you have to say things like "field not in FALSE", etc.)

Still, though, quite powerful, and we hope to push some improvements upstream in relation to my comments here.

Metabase is another great open-source tool: http://www.metabase.com/

Metabase is my new favourite tool: I've probably use it every day to answer some question instead of dropping into the Rails console. Things like: what percentage of orders come from Stripe vs Paypal? Or export a list of users that match this criteria. Or display the top 10 users by some metric.

It makes creating BI charts from a database easy enough that a non-developer can do it. But when the going gets tough, I can still drop down to hand-coded SQL. It was also an easy installation on Heroku.

It's not entirely perfect (combining multiple series on one chart is harder than it needs to be; can only pull data from databases not APIs) but it's been a success so far

Hey I work on Metabase, thanks for the kind words and feedback.

Regarding pulling data from APIs, there's nothing inherently stopping us (or you) from pulling data from APIs (in fact that's what the Google Analytics driver does). Are you looking for integrations with specific 3rd party APIs, or an easier way to integrate with your own APIs?

Feel free to respond here, email me, or file a GitHub issue. Thanks.

I've tried Superset but halted because there is a bug with PostgreSQL ( https://github.com/airbnb/superset/issues/1900 ). I'll be trying Redash to see what's going on. In the mean time, there is a Django project where I've integrated the sql-explorer ( https://github.com/groveco/django-sql-explorer ) and it was well appreciated. Especially the API endpoint.

That bug is long fixed. Many companies use Superset against Postgres / Redshift. Superset now ships with a SQL IDE as well.

Apparently it's still opened ( https://github.com/airbnb/superset/issues/1929 ) and Airbnb is requesting a contributor that iron out specific postgresql bugs.