/incubator-superset

Apache Superset (incubating) is a modern, enterprise-ready business intelligence web application

Primary LanguageJavaScriptApache License 2.0Apache-2.0

Superset

Build Status PyPI version Coverage Status PyPI Join the chat at https://gitter.im/airbnb/superset Documentation dependencies Status

Superset

Apache Superset (incubating) is a modern, enterprise-ready business intelligence web application

[this project used to be named Caravel, and Panoramix in the past]

Screenshots & Gifs

View Dashboards


Slice & dice your data


Query and visualize your data with SQL Lab


Visualize geospatial data with deck.gl


Choose from a wide array of visualizations


Apache Superset

Apache Superset is a data exploration and visualization web application.

Superset provides:

  • An intuitive interface to explore and visualize datasets, and create interactive dashboards.
  • A wide array of beautiful visualizations to showcase your data.
  • Easy, code-free, user flows to drill down and slice and dice the data underlying exposed dashboards. The dashboards and charts acts as a starting point for deeper analysis.
  • A state of the art SQL editor/IDE exposing a rich metadata browser, and an easy workflow to create visualizations out of any result set.
  • An extensible, high granularity security model allowing intricate rules on who can access which product features and datasets. Integration with major authentication backends (database, OpenID, LDAP, OAuth, REMOTE_USER, ...)
  • A lightweight semantic layer, allowing to control how data sources are exposed to the user by defining dimensions and metrics
  • Out of the box support for most SQL-speaking databases
  • Deep integration with Druid allows for Superset to stay blazing fast while slicing and dicing large, realtime datasets
  • Fast loading dashboards with configurable caching

Database Support

Superset speaks many SQL dialects through SQLAlchemy, a Python ORM that is compatible with most common databases.

Superset can be used to visualize data out of most databases:

  • MySQL
  • Postgres
  • Vertica
  • Oracle
  • Microsoft SQL Server
  • SQLite
  • Greenplum
  • Firebird
  • MariaDB
  • Sybase
  • IBM DB2
  • Exasol
  • MonetDB
  • Snowflake
  • Redshift
  • Clickhouse
  • Apache Kylin
  • Apache Drill
  • Google BigQuery
  • more! look for the availability of a SQLAlchemy dialect for your database to find out whether it will work with Superset

Apache Druid (Incubating)!

On top of having the ability to query your relational databases, Superset ships with deep integration with Druid (a real time distributed column-store). When querying Druid, Superset can query humongous amounts of data on top of real time dataset. Note that Superset does not require Druid in any way to function, it's simply another database backend that it can query.

Here's a description of Druid from the http://druid.io website:

Druid is an open-source analytics data store designed for business intelligence (OLAP) queries on event data. Druid provides low latency (real-time) data ingestion, flexible data exploration, and fast data aggregation. Existing Druid deployments have scaled to trillions of events and petabytes of data. Druid is best used to power analytic dashboards and applications.

Installation & Configuration

See in the documentation

Resources

Contributing

Interested in contributing? Casual hacking? Check out Contributing.MD

Who uses Apache Superset (incubating)?

Here's a list of organizations who have taken the time to send a PR to let the world know they are using Superset. Join our growing community!

  1. AiHello
  2. Airbnb
  3. Airboxlab
  4. Aktia Bank plc
  5. American Express
  6. Amino
  7. Apollo GraphQL
  8. Ascendica Development
  9. Astronomer
  10. Brilliant.org
  11. Capital Service S.A.
  12. Clark.de
  13. Cloudsmith
  14. CnOvit
  15. Dial Once
  16. Digit Game Studios
  17. Douban
  18. Endress+Hauser
  19. FBK - ICT center
  20. Faasos
  21. Fordeal
  22. GfK Data Lab
  23. Grassroot
  24. Hostnfly
  25. HuiShouBao
  26. jampp
  27. Konfío
  28. Kuaishou
  29. Lime
  30. Living Goods
  31. Lyft
  32. Maieutical Labs
  33. Myra Labs
  34. Now
  35. PeopleDoc
  36. Ona
  37. Pronto Tools
  38. QPID Health
  39. Qunar
  40. Scoot
  41. ScopeAI
  42. Shopee
  43. Shopkick
  44. Steamroot
  45. Showmax
  46. Tails.com
  47. Tenable
  48. THEICONIC
  49. Tobii
  50. Tooploox
  51. TrustMedis
  52. Twitter
  53. Udemy
  54. VIPKID
  55. Windsor.ai
  56. Yahoo!
  57. Zaihang
  58. Zalando