base on Apache Superset is a Data Visualization and Data Exploration Platform <!-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. --> # Superset [](https://opensource.org/license/apache-2-0) [](https://github.com/apache/superset/tree/latest) [](https://github.com/apache/superset/actions) [](https://badge.fury.io/py/apache-superset) [](https://codecov.io/github/apache/superset) [](https://pypi.python.org/pypi/apache-superset) [](http://bit.ly/join-superset-slack) [](https://superset.apache.org) <picture width="500"> <source width="600" media="(prefers-color-scheme: dark)" src="https://superset.apache.org/img/superset-logo-horiz-dark.svg" alt="Superset logo (dark)" /> <img width="600" src="https://superset.apache.org/img/superset-logo-horiz-apache.svg" alt="Superset logo (light)" /> </picture> A modern, enterprise-ready business intelligence web application. [**Why Superset?**](#why-superset) | [**Supported Databases**](#supported-databases) | [**Installation and Configuration**](#installation-and-configuration) | [**Release Notes**](https://github.com/apache/superset/blob/master/RELEASING/README.md#release-notes-for-recent-releases) | [**Get Involved**](#get-involved) | [**Contributor Guide**](#contributor-guide) | [**Resources**](#resources) | [**Organizations Using Superset**](https://github.com/apache/superset/blob/master/RESOURCES/INTHEWILD.md) ## Why Superset? Superset is a modern data exploration and data visualization platform. Superset can replace or augment proprietary business intelligence tools for many teams. Superset integrates well with a variety of data sources. Superset provides: - A **no-code interface** for building charts quickly - A powerful, web-based **SQL Editor** for advanced querying - A **lightweight semantic layer** for quickly defining custom dimensions and metrics - Out of the box support for **nearly any SQL** database or data engine - A wide array of **beautiful visualizations** to showcase your data, ranging from simple bar charts to geospatial visualizations - Lightweight, configurable **caching layer** to help ease database load - Highly extensible **security roles and authentication** options - An **API** for programmatic customization - A **cloud-native architecture** designed from the ground up for scale ## Screenshots & Gifs **Video Overview** <!-- File hosted here https://github.com/apache/superset-site/raw/lfs/superset-video-4k.mp4 --> [superset-video-4k.webm](https://github.com/apache/superset/assets/812905/da036bc2-150c-4ee7-80f9-75e63210ff76) <br/> **Large Gallery of Visualizations** <kbd><img title="Gallery" src="https://superset.apache.org/img/screenshots/gallery.jpg"/></kbd><br/> **Craft Beautiful, Dynamic Dashboards** <kbd><img title="View Dashboards" src="https://superset.apache.org/img/screenshots/slack_dash.jpg"/></kbd><br/> **No-Code Chart Builder** <kbd><img title="Slice & dice your data" src="https://superset.apache.org/img/screenshots/explore.jpg"/></kbd><br/> **Powerful SQL Editor** <kbd><img title="SQL Lab" src="https://superset.apache.org/img/screenshots/sql_lab.jpg"/></kbd><br/> ## Supported Databases Superset can query data from any SQL-speaking datastore or data engine (Presto, Trino, Athena, [and more](https://superset.apache.org/docs/configuration/databases)) that has a Python DB-API driver and a SQLAlchemy dialect. Here are some of the major database solutions that are supported: <p align="center"> <img src="https://superset.apache.org/img/databases/redshift.png" alt="redshift" border="0" width="200"/> <img src="https://superset.apache.org/img/databases/google-biquery.png" alt="google-biquery" border="0" width="200"/> <img src="https://superset.apache.org/img/databases/snowflake.png" alt="snowflake" border="0" width="200"/> <img src="https://superset.apache.org/img/databases/trino.png" alt="trino" border="0" width="150" /> <img src="https://superset.apache.org/img/databases/presto.png" alt="presto" border="0" width="200"/> <img src="https://superset.apache.org/img/databases/databricks.png" alt="databricks" border="0" width="160" /> <img src="https://superset.apache.org/img/databases/druid.png" alt="druid" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/firebolt.png" alt="firebolt" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/timescale.png" alt="timescale" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/rockset.png" alt="rockset" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/postgresql.png" alt="postgresql" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/mysql.png" alt="mysql" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/mssql-server.png" alt="mssql-server" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/ibm-db2.svg" alt="db2" border="0" width="220" /> <img src="https://superset.apache.org/img/databases/sqlite.png" alt="sqlite" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/sybase.png" alt="sybase" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/mariadb.png" alt="mariadb" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/vertica.png" alt="vertica" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/oracle.png" alt="oracle" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/firebird.png" alt="firebird" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/greenplum.png" alt="greenplum" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/clickhouse.png" alt="clickhouse" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/exasol.png" alt="exasol" border="0" width="160" /> <img src="https://superset.apache.org/img/databases/monet-db.png" alt="monet-db" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/apache-kylin.png" alt="apache-kylin" border="0" width="80"/> <img src="https://superset.apache.org/img/databases/hologres.png" alt="hologres" border="0" width="80"/> <img src="https://superset.apache.org/img/databases/netezza.png" alt="netezza" border="0" width="80"/> <img src="https://superset.apache.org/img/databases/pinot.png" alt="pinot" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/teradata.png" alt="teradata" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/yugabyte.png" alt="yugabyte" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/databend.png" alt="databend" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/starrocks.png" alt="starrocks" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/doris.png" alt="doris" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/oceanbase.svg" alt="oceanbase" border="0" width="220" /> <img src="https://superset.apache.org/img/databases/sap-hana.png" alt="oceanbase" border="0" width="220" /> <img src="https://superset.apache.org/img/databases/denodo.png" alt="denodo" border="0" width="200" /> <img src="https://superset.apache.org/img/databases/ydb.svg" alt="ydb" border="0" width="200" /> </p> **A more comprehensive list of supported databases** along with the configuration instructions can be found [here](https://superset.apache.org/docs/configuration/databases). Want to add support for your datastore or data engine? Read more [here](https://superset.apache.org/docs/frequently-asked-questions#does-superset-work-with-insert-database-engine-here) about the technical requirements. ## Installation and Configuration [Extended documentation for Superset](https://superset.apache.org/docs/installation/docker-compose) ## Get Involved - Ask and answer questions on [StackOverflow](https://stackoverflow.com/questions/tagged/apache-superset) using the **apache-superset** tag - [Join our community's Slack](http://bit.ly/join-superset-slack) and please read our [Slack Community Guidelines](https://github.com/apache/superset/blob/master/CODE_OF_CONDUCT.md#slack-community-guidelines) - [Join our [email protected] Mailing list](https://lists.apache.org/[email protected]). To join, simply send an email to [[email protected]](mailto:[email protected]) - If you want to help troubleshoot GitHub Issues involving the numerous database drivers that Superset supports, please consider adding your name and the databases you have access to on the [Superset Database Familiarity Rolodex](https://docs.google.com/spreadsheets/d/1U1qxiLvOX0kBTUGME1AHHi6Ywel6ECF8xk_Qy-V9R8c/edit#gid=0) - Join Superset's Town Hall and [Operational Model](https://preset.io/blog/the-superset-operational-model-wants-you/) recurring meetings. Meeting info is available on the [Superset Community Calendar](https://superset.apache.org/community) ## Contributor Guide Interested in contributing? Check out our [CONTRIBUTING.md](https://github.com/apache/superset/blob/master/CONTRIBUTING.md) to find resources around contributing along with a detailed guide on how to set up a development environment. ## Resources - [Superset "In the Wild"](https://github.com/apache/superset/blob/master/RESOURCES/INTHEWILD.md) - open a PR to add your org to the list! - [Feature Flags](https://github.com/apache/superset/blob/master/RESOURCES/FEATURE_FLAGS.md) - the status of Superset's Feature Flags. - [Standard Roles](https://github.com/apache/superset/blob/master/RESOURCES/STANDARD_ROLES.md) - How RBAC permissions map to roles. - [Superset Wiki](https://github.com/apache/superset/wiki) - Tons of additional community resources: best practices, community content and other information. - [Superset SIPs](https://github.com/orgs/apache/projects/170) - The status of Superset's SIPs (Superset Improvement Proposals) for both consensus and implementation status. Understanding the Superset Points of View - [The Case for Dataset-Centric Visualization](https://preset.io/blog/dataset-centric-visualization/) - [Understanding the Superset Semantic Layer](https://preset.io/blog/understanding-superset-semantic-layer/) - Getting Started with Superset - [Superset in 2 Minutes using Docker Compose](https://superset.apache.org/docs/installation/docker-compose#installing-superset-locally-using-docker-compose) - [Installing Database Drivers](https://superset.apache.org/docs/configuration/databases#installing-database-drivers) - [Building New Database Connectors](https://preset.io/blog/building-database-connector/) - [Create Your First Dashboard](https://superset.apache.org/docs/using-superset/creating-your-first-dashboard/) - [Comprehensive Tutorial for Contributing Code to Apache Superset ](https://preset.io/blog/tutorial-contributing-code-to-apache-superset/) - [Resources to master Superset by Preset](https://preset.io/resources/) - Deploying Superset - [Official Docker image](https://hub.docker.com/r/apache/superset) - [Helm Chart](https://github.com/apache/superset/tree/master/helm/superset) - Recordings of Past [Superset Community Events](https://preset.io/events) - [Mixed Time Series Charts](https://preset.io/events/mixed-time-series-visualization-in-superset-workshop/) - [How the Bing Team Customized Superset for the Internal Self-Serve Data & Analytics Platform](https://preset.io/events/how-the-bing-team-heavily-customized-superset-for-their-internal-data/) - [Live Demo: Visualizing MongoDB and Pinot Data using Trino](https://preset.io/events/2021-04-13-visualizing-mongodb-and-pinot-data-using-trino/) - [Introduction to the Superset API](https://preset.io/events/introduction-to-the-superset-api/) - [Building a Database Connector for Superset](https://preset.io/events/2021-02-16-building-a-database-connector-for-superset/) - Visualizations - [Creating Viz Plugins](https://superset.apache.org/docs/contributing/creating-viz-plugins/) - [Managing and Deploying Custom Viz Plugins](https://medium.com/nmc-techblog/apache-superset-manage-custom-viz-plugins-in-production-9fde1a708e55) - [Why Apache Superset is Betting on Apache ECharts](https://preset.io/blog/2021-4-1-why-echarts/) - [Superset API](https://superset.apache.org/docs/rest-api) ## Repo Activity <a href="https://next.ossinsight.io/widgets/official/compose-last-28-days-stats?repo_id=39464018" target="_blank" align="center"> <picture> <source media="(prefers-color-scheme: dark)" srcset="https://next.ossinsight.io/widgets/official/compose-last-28-days-stats/thumbnail.png?repo_id=39464018&image_size=auto&color_scheme=dark" width="655" height="auto" /> <img alt="Performance Stats of apache/superset - Last 28 days" src="https://next.ossinsight.io/widgets/official/compose-last-28-days-stats/thumbnail.png?repo_id=39464018&image_size=auto&color_scheme=light" width="655" height="auto" /> </picture> </a> <!-- Made with [OSS Insight](https://ossinsight.io/) --> <!-- telemetry/analytics pixel: --> <img referrerpolicy="no-referrer-when-downgrade" src="https://static.scarf.sh/a.png?x-pxid=bc1c90cd-bc04-4e11-8c7b-289fb2839492" /> ", Assign "at most 3 tags" to the expected json: {"id":"1481","tags":[]} "only from the tags list I provide: [{"id":77,"name":"3d"},{"id":89,"name":"agent"},{"id":17,"name":"ai"},{"id":54,"name":"algorithm"},{"id":24,"name":"api"},{"id":44,"name":"authentication"},{"id":3,"name":"aws"},{"id":27,"name":"backend"},{"id":60,"name":"benchmark"},{"id":72,"name":"best-practices"},{"id":39,"name":"bitcoin"},{"id":37,"name":"blockchain"},{"id":1,"name":"blog"},{"id":45,"name":"bundler"},{"id":58,"name":"cache"},{"id":21,"name":"chat"},{"id":49,"name":"cicd"},{"id":4,"name":"cli"},{"id":64,"name":"cloud-native"},{"id":48,"name":"cms"},{"id":61,"name":"compiler"},{"id":68,"name":"containerization"},{"id":92,"name":"crm"},{"id":34,"name":"data"},{"id":47,"name":"database"},{"id":8,"name":"declarative-gui "},{"id":9,"name":"deploy-tool"},{"id":53,"name":"desktop-app"},{"id":6,"name":"dev-exp-lib"},{"id":59,"name":"dev-tool"},{"id":13,"name":"ecommerce"},{"id":26,"name":"editor"},{"id":66,"name":"emulator"},{"id":62,"name":"filesystem"},{"id":80,"name":"finance"},{"id":15,"name":"firmware"},{"id":73,"name":"for-fun"},{"id":2,"name":"framework"},{"id":11,"name":"frontend"},{"id":22,"name":"game"},{"id":81,"name":"game-engine "},{"id":23,"name":"graphql"},{"id":84,"name":"gui"},{"id":91,"name":"http"},{"id":5,"name":"http-client"},{"id":51,"name":"iac"},{"id":30,"name":"ide"},{"id":78,"name":"iot"},{"id":40,"name":"json"},{"id":83,"name":"julian"},{"id":38,"name":"k8s"},{"id":31,"name":"language"},{"id":10,"name":"learning-resource"},{"id":33,"name":"lib"},{"id":41,"name":"linter"},{"id":28,"name":"lms"},{"id":16,"name":"logging"},{"id":76,"name":"low-code"},{"id":90,"name":"message-queue"},{"id":42,"name":"mobile-app"},{"id":18,"name":"monitoring"},{"id":36,"name":"networking"},{"id":7,"name":"node-version"},{"id":55,"name":"nosql"},{"id":57,"name":"observability"},{"id":46,"name":"orm"},{"id":52,"name":"os"},{"id":14,"name":"parser"},{"id":74,"name":"react"},{"id":82,"name":"real-time"},{"id":56,"name":"robot"},{"id":65,"name":"runtime"},{"id":32,"name":"sdk"},{"id":71,"name":"search"},{"id":63,"name":"secrets"},{"id":25,"name":"security"},{"id":85,"name":"server"},{"id":86,"name":"serverless"},{"id":70,"name":"storage"},{"id":75,"name":"system-design"},{"id":79,"name":"terminal"},{"id":29,"name":"testing"},{"id":12,"name":"ui"},{"id":50,"name":"ux"},{"id":88,"name":"video"},{"id":20,"name":"web-app"},{"id":35,"name":"web-server"},{"id":43,"name":"webassembly"},{"id":69,"name":"workflow"},{"id":87,"name":"yaml"}]" returns me the "expected json"