Table of Contents 1. What is superset? 2. Install superset 3. Initialization of supetset database after installation 1. Error 1: cannot import name ‘url_quote’ from ‘werkzeug.urls’ 2. Error 2: AttributeError: module ‘sqlparse.keywords’ has no attribute ‘FLAGS’ 3. Mistake 3: You did not provide the “FLASK_APP” environment variable 4. Mistake 4: Refusing to start due to […]
Tag: superset
Use Docker to deploy Apache Superset and achieve remote access over the public network
Big data visual BI analysis tool Apache Superset enables remote access over the public network Article directory Big data visual BI analysis tool Apache Superset enables remote access over the public network Preface 1. Deploy Apache Superset using Docker 1.1 The first step is to install docker and docker compose 1.2 Clone the superset code […]
superset supports Kylin4.0.0 (compatible with date grouping function)
Problem summary 1. superset does not support kylin data source by default Install kylinpy pip install kylinpy 2. After installing the kylin driver, the kylin address cannot be connected Modify the site-packages/kylinpy/sqla_dialect.py file 2.1 Annotate the content #def _compose_select_body(self, text, select, inner_columns, froms, byfrom, kwargs): # text = super(KylinSQLCompiler, self)._compose_select_body( # text, select, inner_columns, froms, […]
Stand-alone installation of superset3.0 under centos7.5
Recently I want to try the open source BI superset. There are many good articles on the Internet, but the versions are low and it is easy to make mistakes when installing them. Record the problems during the installation process and the installation was successful. Running environment: Centos7.5 + miniconda + python3.9 + superset3.0 1. […]
Superset is an efficient data source chart display tool.
Superset introduction Apache Superset is a modern data exploration and visualization platform. It is powerful and easy to use. It can connect to various data sources, including many modern big data analysis engines, has rich chart display forms, and supports customized dashboards. Official website https://superset.apache.org/ Superset installation Install Python environment superset is a web application […]
SupersetBI integrates Echarts
Development environment deployment: SupersetBI secondary development environment deployment_Jianweixiaoshipian-‘s blog-CSDN blog superset version: 2.0.0 echarts version: 5.3.1 Foreword: Reference article: Superset secondary development Add new legend | Travel Application Document Center (qq.com) Process: 1. Create a new Gauge folder under the \superset-frontend\src\visualizations folder Create a new images folder Create new GaugeChartPlugin.js import { t } from […]
[BI Kanban] Secondary development of Superset time filter control
Has anyone found that the Superset time filter component is very advanced, but a bit complicated, and there is no shortcut for selecting a time interval. Superset’s time filter control can be customized through secondary development in code. Here are some tips that may be helpful: Find the source code: You can find the relevant […]
Open source BI framework comparison selection Superset-Redash-Metabase
Open source BI framework, I learned about the three mainstream Superset-Redash-Metabase from Open source solutions for data visualization: Superset vs Redash vs Metabase. And the article also introduces the corresponding framework selection, chart richness and other introductions. However, after more than a year, redash has been embraced by databricks, and I personally feel that it […]
Initializing the superset database error
miniconda change source Create a virtual environment error Solution: 1. vim ~/.condarc 2. Replace the contents with channels: – defaults show_channel_urls: true channel_alias: https://mirrors.tuna.tsinghua.edu.cn/anaconda default_channels: – https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/main – https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/free – https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/r – https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/pro – https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/msys2 custom_channels: conda-forge: https://mirrors.tuna.tsinghua.edu.cn/anaconda/cloud msys2: https://mirrors.tuna.tsinghua.edu.cn/anaconda/cloud bioconda: https://mirrors.tuna.tsinghua.edu.cn/anaconda/cloud menpo: https://mirrors.tuna.tsinghua.edu.cn/anaconda/cloud pytorch: https://mirrors.tuna.tsinghua.edu.cn/anaconda/cloud simpleitk: https://mirrors.tuna.tsinghua.edu.cn/anaconda/cloud See the blog: Solve the problem that […]
Apache Superset Unauthorized Access Vulnerability (CVE-2023-27524)
Apache Superset has an unauthorized access vulnerability [CVE-2023-27524] detailed utilization process Disclaimer: 1. Introduction to Apache Superset 2. Vulnerability description Three, the impact version 4. fofa query statement 5. Vulnerability recurrence 6. POC & amp; EXP Batch detection tool Tool download link 7. Opinions on rectification Disclaimer: Do not use the relevant technologies in this […]