Starting with Redash v3, it can integrate with LDAP/AD and SSO. Metabase is a Python implementation, and you can extend the suite if required. Also, you can set up alerts to notify when a specific query reaches a preset value.
With Redash, you can automatically update your charts and dashboards at regular intervals you define. With out-of-the-box rich visualizations, one can quickly run SQL queries and easily build visualizations and dashboards to drive business insights. It allows users to explore, query, visualize and share data from most data sources. Redash is a powerful BI tool that is meant for advanced users as it requires SQL knowledge. Though Databricks, the company behind Apache Spark, recently acquired Redash, it continues as an open-source project. When it comes to databases, it currently supports Postgres, MySQL, Druid, SQL Server, Redshift, MongoDB, Google BigQuery, SQLite, H2, Oracle, Vertica, Presto, Snowflake, and SparkSQL.Ĭurrently, Metabase has 19,229 commits and 228 contributors. It can integrate with Google OAuth, LDAP, and SSO. Metabase is a Closure implementation, and you can extend the suite if required. You can deliver a pulse via email or Slack, on the schedule of your choice. Metabase has a feature called "Pulses, " which automatically gives you the ability to automatically send regular updates on specific queries or metrics that matter to you most. Or you can create a dashboard straight with basic SQL.
You can start creating a dashboard by merely asking a question, and a wizard will walk you through the series of steps. It's another intuitive tool to configure and create dashboards without any technical expertise. It is an easy, open-source way for everyone (including non-technical users) to ask questions and learn from data. Metabase is a BI tool to provide data insights and visualizations. It currently supports Amazon Athena, Amazon Redshift, Apache Drill, Apache Druid, Apache Hive, Apache Impala, Apache Kylin, Apache Pinot, Apache Spark SQL, BigQuery, ClickHouse, CockroachDB, Dremio, Elasticsearch, Exasol, Google Sheets, Greenplum, IBM Db2, MySQL, Oracle, PostgreSQL, Presto, Snowflake, SQLite, SQL Server, Teradata, Vertica, and Hana.Ĭurrently, Superset has 5,429 commits and 467 contributors. Superset speaks many SQL dialects through SQLAlchemy (a Python SQL toolkit) compatible with most databases. It can integrate with LDAP, OpenId, Google OAuth, and SSO. Superset is a Python implementation, and you can extend the suite if required. With basic SQL, you can create rich dashboards by connecting to multiple data stores. Out of the box, it provides various rich visualizations. Superset is a modern BI tool with a self intuitive interface to create and customize dashboards.
It's currently an incubation project, but I am confident it will become the Apache foundation's main project. Superset started as an internal project at Airbnb and later became an open-source project at Apache. Open-source BI tools Apache Superset, Metabase, and Redash, are gaining popularity as they are self-intuitive even for non-technical users. While many libraries focus on plotting charts and visualizations, three frameworks focus on the entire BI & Analytics suite i.e., connecting various data sources to creating dashboards using drag ' n' drop components to plotting charts.
īesides these acquisitions and fundings, there has been a lot of momentum in the open-source community around BI & Analytics tools.