I am looking for service or tool similiar to Metabase or Redash that allows me to add data source – for example Postgres connection, and create raw SQL queries that can be shared or exposed through API. So instead of keeping raw SQL code somewhere, my other service would call this tool e.g. http://microservice/query=1?param1=xx&page=2 and get the results from the DB.
These calls are internal only and part of ETL…

Source:
about 1 year ago

I have tried Metabase, Redash beore (both self hosted open source versions), from my experience I find Metabase a bit easy to work with.

Source:
over 1 year ago

Regarding visualization tools, sqliteviz has proven to be the best I’ve found so far. Their web app runs locally but has some trackers, so I run it locally via a simple, static HTTP server. Falcon and Redash seem like overkill for my needs.

Source:
over 1 year ago

In addition to metabase there are redash[0] and apache superset[1]. They are more or less similar to metabase with some different quirks. You can also visualize quite a bit of data in grafana[2] as well. [0] https://redash.io/ [1] https://superset.apache.org/ [2] https://github.com/grafana/grafana.

– Source: Hacker News
/
almost 2 years ago

This is typically called a “dashboard” and there is a whole industry of existing commercial products (for example https://redash.io/) that are built around doing data analysis and visualization.

Source:
about 2 years ago

There seems enough competitors when this looks like a tool from 20 years ago with limited functionality. If you somehow do not use the obvious GUI tools like TablePlus, Postico or SequelAce but prefer web based, there are some that actually look modern. https://www.getmotoradmin.com/ https://www.nocodb.com/ https://redash.io/ For readonly usage, Metabase is good.

– Source: Hacker News
/
over 2 years ago

Something like https://redash.io with https://n8n.io connected to InfluxDB?

Source:
over 2 years ago

We use a self hosted redash instance to visualize the data with dashboards and whatnot.

Source:
over 2 years ago

How

You might like to use tools like Redash as it is just for viewing and querying data, and you don’t have to navigate through the rest of the platform to find it.

– Source: dev.to
/
over 2 years ago

Redash(https://redash.io/) is pretty easy to use and get up and started with, especially if you know SQL. It’s free and open source.

– Source: Hacker News
/
over 2 years ago

I would go further and say, in a crowded space like that with some excellent free options (i’d also add https://redash.io/ to the list which is very pleasant to work with), you need to show what actually differentiates you from those free and mature solutions.

– Source: Hacker News
/
over 2 years ago

Its a bad idea use Redash as ETL and Data warehouse?
Im not a data engineer just looking for a low/mid scale solution for experiment.

Source:
over 2 years ago

Regarding the subqueries: try https://tablum.io or https://redash.io, they materialize queried data so you can do a subquery multiple times.

Source:
almost 3 years ago

Take a look at Apache Superset, Metabase and Redash.

Source:
almost 3 years ago

Redash is open source – https://redash.io/.

Source:
about 3 years ago

Also Redash which I find to be more powerful: https://redash.io/.

– Source: Hacker News
/
over 3 years ago

This is cool! I’ve had a lot of success with http://redash.io, which is a similar (though much more complex) project. SQL backend +visualizations can be really powerful and surprisingly flexible for building dashboards that aren’t quite ad-hoc, but don’t deserve their own standalone app and you just need to tie some input fields into SQL parameters.

– Source: Hacker News
/
over 3 years ago

Re:dash (acquired by Databricks but still BSD-licensed open source).

Source:
over 3 years ago

Not exactly for “input data” but using already existing in (almost any) database and create realtime charts: Redash.

Source:
over 3 years ago