Bummer that it can't pull data from JSON APIs, which Redash can do.
Apache Superset
161–170 of 201 posts
Re: Apache Superset
#162Is Superset a decent tool if you're just a single person doing data analysis? Say I have a handful of sqlite databases, and just want to be able to develop some queries / charts. I was looking into Tableau / Power BI / Superset, and all of them seemed pretty heavyweight for a single user, and none of them seemed super easy to get setup locally. Any recommendations for a good piece of software for the single user case…
Tableau is the best, most powerful, most mature of the three, most feature complete and easiest of the three. I think they give you a 30 day trial. This is a single user application, unless you make it part of your built application.
> This is a single user application
K8s installation instructions: https://superset.apache.org/docs/installation/running-on-kub...
RBAC configuration: https://superset.apache.org/docs/security/#rest-api-for-user...
Re: Apache Superset
#163Earlier quoted context omitted.
Yes, I am at a company using Metabase, but I have a decent amount of experience with Superset (albeit from many years ago). The reason we chose Metabase was that it had table joins, while Superset doesn't (unless it has added them since I used it). It also looks a bit sleeker. But I strongly prefer Superset; I found that with Metabase I had to turn a lot of things off to make it usable (Let me see "the_table" not "Th…
Superset lets you join tables within the same database. If you want to do cross-DB joins, we have a new (beta) in-memory meta-DB that lets you do this, but we generally see and recommend people using things like Trino for this.
Nice! When was that added?
Re: Apache Superset
#164Surprised no one has mentioned hex yet. There was a post on the yc internal forum today about data stacks and a lot of founders mentioned they liked hex. I hadn't heard too much about them before but they looked interesting for someone (me) who typically prefers something closer to a jupyter notebook and simple stacks.
Re: Apache Superset
#165How does it compare to Kibana + Elasticsearch?
A big thing here is that Superset and most of the other BI tools can connect directly to databases which is commonly the source of truth or data warehouse in some businesses.
Secondly, Elastic have focused on other operational areas such as security, observability, and indexing / search.
Kibana can do some dashboarding on those areas and its UI is nice, but Superset and similar tooling are more suited for BI purposes.
Re: Apache Superset
#166Earlier quoted context omitted.
Tableau is the best, most powerful, most mature of the three, most feature complete and easiest of the three. I think they give you a 30 day trial. This is a single user application, unless you make it part of your built application.
Superset isn't a single user application?
Ah, sure
Re: Apache Superset
#167Tried installing it, locally in a Python Virtual Env. Apparently installation will not work with Python 3.12, dur to deprecation of distutils. Does anyone have any method to install this?
Maybe try the Docker installation to keep the dependencies off your system:
https://superset.apache.org/docs/installation/installing-sup...
Re: Apache Superset
#168Is this capable of performing efficient JOINs across non-homogeneous data-stores?
We use https://cube.dev/ as intermediate layer between data warehouse database and Superset (and other "terminal" apps for BI like report generators). You define your schema (metrics, dimensions, joins, calculated metrics etc) in cube and then access them by any tool that can connect to SQL db
Re: Apache Superset
#169Full fledged BI tools like Superset and Metabase are amazing for their intended use cases.
But they may be an overkill if your primary use case is to infrequently build semi-interactive reports for non-technical end-users and your use cases are are mostly covered by standard graphs & tables. Esp. so if you are familiar with SQL and have access to the underlying data source. Two nifty utilities I have found to be very useful for latter kind of use cases are SQLPage and Evidence.
They make it very convenient to whip out some SQL and convert that to a neat professional looking web ui that can be forwarded to an end user. In case of Evidence it is a statically generated site, and in case of SQLPage it is a web app that connects to a live database.
SQLPage: https://sql.ophir.dev/
Evidence: https://evidence.dev
Re: Apache Superset
#170This looks like grafana, right? Why would I use this instead of grafana?
I love Grafana but Grafana doesn't really support non-time-series visualization that well.
Why is that, though? I'd think that there'd be some plugins/extensions for Grafana that could do this. Grafana could then become the next PowerBI/Tableau/Superset killer eventually.