metricflow
Apache Superset
Our great sponsors
metricflow | Apache Superset | |
---|---|---|
4 | 3 | |
1,073 | 34,745 | |
2.5% | - | |
9.8 | 9.9 | |
4 days ago | about 3 years ago | |
Python | Python | |
GNU General Public License v3.0 or later | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
metricflow
- MetricFlow allows you to define, build, and maintain metrics in code.
-
Show HN: MetricFlow – open-source metric framework
Three things:
First, MetricFlow does not currently support MySQL. We launched with support for BigQuery, Redshift, and Snowflake. I have opened an issue to add support for MySQL (and similar issues for other SQL engines are coming): https://github.com/transform-data/metricflow/issues/27
Second, what we call a data source is more similar to a table in a database, rather than the underlying database service itself. Metricflow itself is useful when you're using a single SQL engine - indeed, that's all we support today - but it is most useful when you're in a world where joins are a thing. That said, if you have one big data table you might still find it useful to have declarative metric definitions defined in Metricflow. Suppose, for example, you had a big NoSQL style table filled with JSON objects. You might define a few data sources that normalize those JSON objects into top level elements (identifiers, dimensions, aggregated measures) using the sql_query data source config attribute, and then that'd allow you to support structured queries on the data consumption end while pushing unstructured blobs from your application layer. This will be slow at query time, and only as reliable as the level of discipline exerted in your application development workflow, but it's possible.
Third, if we did support MySQL you'd basically connect to it via standard connection parameters - we have a config file where you can store the required information and then we'll manage the connections for you. However, I'm not familiar with uxwizz, and a quick perusal of their documentation did not turn up how one goes about connecting to the underlying DB. It's likely I just missed this, but at any rate I don't know how it is done. If they don't support standard MySQL client connections you'd need to write an adapter of some kind against whatever DB connection APIs they provide, in which case you'd likely need to roll a custom implementation of MetricFlow's SqlClient interface and initialize the MetricFlowEngine with that.
Apache Superset
-
Using KeyCloak(OpenID Connect) with Apache SuperSet
The first difference is that after pull request 4565 was merged, you can no longer do:
-
Open Source Analytics Stack: Bringing Control, Flexibility, and Data-Privacy to Your Analytics
Open-source BI platforms such as Metabase (website, GitHub) and Apache SuperSet (website, GitHub) are easy to deploy without IT involvement. Metabase lets you build dashboards from the data in your warehouse easily, with no SQL, or, if you have data engineering or science know-how, inside more powerful and flexible notebooks or with SQL itself. Similarly, Apache SuperSet helps businesses explore and visualize data from simple line charts to detailed geospatial charts.
-
Ask HN: What low-code “dashboarding“ SaaS would you recommend in 2021?
Check out Superset. https://github.com/apache/incubator-superset
It’s modern, easy to extend. From the same author of apache airflow.
What are some alternatives?
dbt-core - dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
plotly - The interactive graphing library for Python :sparkles: This project now includes Plotly Express!
dbt_metrics - Macros for calculating metrics
Grafana - The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
dictum - Describe business metrics with YAML, query and visualize in Jupyter with zero SQL
Metabase - The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
dbt - dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications. [Moved to: https://github.com/dbt-labs/dbt-core]
Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
datafluent_pg - Build a better understanding of your data in PostgreSQL.
Elasticsearch - Free and Open, Distributed, RESTful Search Engine
cube.js - 📊 Cube — The Semantic Layer for Building Data Applications
grafanalib - Python library for building Grafana dashboards