kandi background
Explore Kits

incubator-superset | Apache Superset is a Data Visualization | Data Visualization library

 by   apache Python Version: 0.38.0 License: Apache-2.0

 by   apache Python Version: 0.38.0 License: Apache-2.0

Download this library from

kandi X-RAY | incubator-superset Summary

incubator-superset is a Python library typically used in Analytics, Data Visualization applications. incubator-superset has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has medium support. You can install using 'pip install incubator-superset' or download it from GitHub, PyPI.
<!-- 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. 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. -→.
Support
Support
Quality
Quality
Security
Security
License
License
Reuse
Reuse

kandi-support Support

  • incubator-superset has a medium active ecosystem.
  • It has 31662 star(s) with 6530 fork(s). There are 1312 watchers for this library.
  • It had no major release in the last 12 months.
  • There are 393 open issues and 4913 have been closed. On average issues are closed in 103 days. There are 82 open pull requests and 0 closed requests.
  • It has a neutral sentiment in the developer community.
  • The latest version of incubator-superset is 0.38.0
incubator-superset Support
Best in #Data Visualization
Average in #Data Visualization
incubator-superset Support
Best in #Data Visualization
Average in #Data Visualization

quality kandi Quality

  • incubator-superset has 0 bugs and 0 code smells.
incubator-superset Quality
Best in #Data Visualization
Average in #Data Visualization
incubator-superset Quality
Best in #Data Visualization
Average in #Data Visualization

securitySecurity

  • incubator-superset has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
  • incubator-superset code analysis shows 0 unresolved vulnerabilities.
  • There are 0 security hotspots that need review.
incubator-superset Security
Best in #Data Visualization
Average in #Data Visualization
incubator-superset Security
Best in #Data Visualization
Average in #Data Visualization

license License

  • incubator-superset is licensed under the Apache-2.0 License. This license is Permissive.
  • Permissive licenses have the least restrictions, and you can use them in most projects.
incubator-superset License
Best in #Data Visualization
Average in #Data Visualization
incubator-superset License
Best in #Data Visualization
Average in #Data Visualization

buildReuse

  • incubator-superset releases are available to install and integrate.
  • Deployable package is available in PyPI.
  • Build file is available. You can build the component from source.
  • Installation instructions, examples and code snippets are available.
  • incubator-superset saves you 62371 person hours of effort in developing the same functionality from scratch.
  • It has 70846 lines of code, 3283 functions and 1365 files.
  • It has medium code complexity. Code complexity directly impacts maintainability of the code.
incubator-superset Reuse
Best in #Data Visualization
Average in #Data Visualization
incubator-superset Reuse
Best in #Data Visualization
Average in #Data Visualization
Top functions reviewed by kandi - BETA

Coming Soon for all Libraries!

Currently covering the most popular Java, JavaScript and Python libraries. See a SAMPLE HERE.
kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.

incubator-superset Key Features

Apache Superset is a Data Visualization and Data Exploration Platform

default

copy iconCopydownload iconDownload
http://www.apache.org/licenses/LICENSE-2.0

No package metadata was found for apache-superset

copy iconCopydownload iconDownload
(superset) cwj0@ubuntu:~/anaconda3/envs/superset/lib/python3.7/site-packages/incubator-superset$ pip install -r requirements/local.txt

(superset) cwj0@ubuntu:~/anaconda3/envs/superset/lib/python3.7/site-packages/incubator-superset$ pip install -e .

(superset) cwj0@ubuntu:~/anaconda3/envs/superset/lib/python3.7/site-packages/incubator-superset$ superset init
Loaded your LOCAL configuration at [/home/cwj0/anaconda3/envs/superset/lib/python3.7/site-packages/incubator-superset/superset_config.py]
logging was configured successfully
2022-01-14 08:45:43,385:INFO:superset.utils.logging_configurator:logging was configured successfully
2022-01-14 08:45:43,428:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
Syncing role definition
2022-01-14 08:45:48,268:INFO:superset.security.manager:Syncing role definition
Syncing Admin perms
2022-01-14 08:45:48,296:INFO:superset.security.manager:Syncing Admin perms
Syncing Alpha perms
2022-01-14 08:45:48,538:INFO:superset.security.manager:Syncing Alpha perms
Syncing Gamma perms
2022-01-14 08:45:48,784:INFO:superset.security.manager:Syncing Gamma perms
Syncing granter perms
2022-01-14 08:45:49,031:INFO:superset.security.manager:Syncing granter perms
Syncing sql_lab perms
2022-01-14 08:45:49,270:INFO:superset.security.manager:Syncing sql_lab perms
Fetching a set of all perms to lookup which ones are missing
2022-01-14 08:45:49,498:INFO:superset.security.manager:Fetching a set of all perms to lookup which ones are missing
Creating missing datasource permissions.
2022-01-14 08:45:49,723:INFO:superset.security.manager:Creating missing datasource permissions.
Creating missing database permissions.
2022-01-14 08:45:49,752:INFO:superset.security.manager:Creating missing database permissions.
Cleaning faulty perms
2022-01-14 08:45:49,756:INFO:superset.security.manager:Cleaning faulty perms

I have mysql and apache superset setup on dockers and connected by a bridge network, what will theSQLAlchemy URI be?

copy iconCopydownload iconDownload
 Plugin caching_sha2_password could not be loaded:
from sqlalchemy import create_engine
engine = create_engine('mysql://root:sample@172.19.0.5/mysql')
engine.connect()
   sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1045, 'Plugin caching_sha2_password could not be loaded: /usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory')
    (Background on this error at: http://sqlalche.me/e/13/e3q8)
docker run --detach --network="incubator-superset_default" --name=mysql --env="MYSQL_ROOT_PASSWORD=sample" --publish 3306:3306 mysql --default-authentication-plugin=mysql_native_password 
mysql://root:sample@mysql/mysql
mysql://root:sample@172.19.0.5/mysql
-----------------------
 Plugin caching_sha2_password could not be loaded:
from sqlalchemy import create_engine
engine = create_engine('mysql://root:sample@172.19.0.5/mysql')
engine.connect()
   sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1045, 'Plugin caching_sha2_password could not be loaded: /usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory')
    (Background on this error at: http://sqlalche.me/e/13/e3q8)
docker run --detach --network="incubator-superset_default" --name=mysql --env="MYSQL_ROOT_PASSWORD=sample" --publish 3306:3306 mysql --default-authentication-plugin=mysql_native_password 
mysql://root:sample@mysql/mysql
mysql://root:sample@172.19.0.5/mysql
-----------------------
 Plugin caching_sha2_password could not be loaded:
from sqlalchemy import create_engine
engine = create_engine('mysql://root:sample@172.19.0.5/mysql')
engine.connect()
   sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1045, 'Plugin caching_sha2_password could not be loaded: /usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory')
    (Background on this error at: http://sqlalche.me/e/13/e3q8)
docker run --detach --network="incubator-superset_default" --name=mysql --env="MYSQL_ROOT_PASSWORD=sample" --publish 3306:3306 mysql --default-authentication-plugin=mysql_native_password 
mysql://root:sample@mysql/mysql
mysql://root:sample@172.19.0.5/mysql
-----------------------
 Plugin caching_sha2_password could not be loaded:
from sqlalchemy import create_engine
engine = create_engine('mysql://root:sample@172.19.0.5/mysql')
engine.connect()
   sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1045, 'Plugin caching_sha2_password could not be loaded: /usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory')
    (Background on this error at: http://sqlalche.me/e/13/e3q8)
docker run --detach --network="incubator-superset_default" --name=mysql --env="MYSQL_ROOT_PASSWORD=sample" --publish 3306:3306 mysql --default-authentication-plugin=mysql_native_password 
mysql://root:sample@mysql/mysql
mysql://root:sample@172.19.0.5/mysql
-----------------------
 Plugin caching_sha2_password could not be loaded:
from sqlalchemy import create_engine
engine = create_engine('mysql://root:sample@172.19.0.5/mysql')
engine.connect()
   sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1045, 'Plugin caching_sha2_password could not be loaded: /usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory')
    (Background on this error at: http://sqlalche.me/e/13/e3q8)
docker run --detach --network="incubator-superset_default" --name=mysql --env="MYSQL_ROOT_PASSWORD=sample" --publish 3306:3306 mysql --default-authentication-plugin=mysql_native_password 
mysql://root:sample@mysql/mysql
mysql://root:sample@172.19.0.5/mysql

How to configure Celery Worker and Beat for Email Reporting in Apache Superset running on Docker?

copy iconCopydownload iconDownload
celery worker --app=superset.tasks.celery_app:app --pool=prefork -O fair -c 4 -B
-----------------------
REDIS_HOST = get_env_variable("REDIS_HOST")
REDIS_PORT = get_env_variable("REDIS_PORT")

class CeleryConfig(object):
    BROKER_URL = "redis://%s:%s/0" % (REDIS_HOST, REDIS_PORT)
    CELERY_IMPORTS = (
        'superset.sql_lab',
        'superset.tasks',
    )
    CELERY_RESULT_BACKEND = "redis://%s:%s/1" % (REDIS_HOST, REDIS_PORT)
    CELERY_ANNOTATIONS = {
        'sql_lab.get_sql_results': {
            'rate_limit': '100/s',
        },
        'email_reports.send': {
            'rate_limit': '1/s',
            'time_limit': 120,
            'soft_time_limit': 150,
            'ignore_result': True,
        },
    }
    CELERY_TASK_PROTOCOL = 1
    CELERYBEAT_SCHEDULE = {
        'email_reports.schedule_hourly': {
            'task': 'email_reports.schedule_hourly',
            'schedule': crontab(minute='1', hour='*'),
        },
    }
  superset-worker:
    build: *superset-build
    command: ["celery", "worker", "--app=superset.tasks.celery_app:app", "-Ofair"]
    env_file: docker/.env
    restart: unless-stopped
    depends_on: *superset-depends-on
    volumes: *superset-volumes

  superset-beat:
    build: *superset-build
    command: ["celery", "beat", "--app=superset.tasks.celery_app:app", "--pidfile=", "-f", "/app/celery_beat.log"]
    env_file: docker/.env
    restart: unless-stopped
    depends_on: *superset-depends-on
    volumes: *superset-volumes
-----------------------
REDIS_HOST = get_env_variable("REDIS_HOST")
REDIS_PORT = get_env_variable("REDIS_PORT")

class CeleryConfig(object):
    BROKER_URL = "redis://%s:%s/0" % (REDIS_HOST, REDIS_PORT)
    CELERY_IMPORTS = (
        'superset.sql_lab',
        'superset.tasks',
    )
    CELERY_RESULT_BACKEND = "redis://%s:%s/1" % (REDIS_HOST, REDIS_PORT)
    CELERY_ANNOTATIONS = {
        'sql_lab.get_sql_results': {
            'rate_limit': '100/s',
        },
        'email_reports.send': {
            'rate_limit': '1/s',
            'time_limit': 120,
            'soft_time_limit': 150,
            'ignore_result': True,
        },
    }
    CELERY_TASK_PROTOCOL = 1
    CELERYBEAT_SCHEDULE = {
        'email_reports.schedule_hourly': {
            'task': 'email_reports.schedule_hourly',
            'schedule': crontab(minute='1', hour='*'),
        },
    }
  superset-worker:
    build: *superset-build
    command: ["celery", "worker", "--app=superset.tasks.celery_app:app", "-Ofair"]
    env_file: docker/.env
    restart: unless-stopped
    depends_on: *superset-depends-on
    volumes: *superset-volumes

  superset-beat:
    build: *superset-build
    command: ["celery", "beat", "--app=superset.tasks.celery_app:app", "--pidfile=", "-f", "/app/celery_beat.log"]
    env_file: docker/.env
    restart: unless-stopped
    depends_on: *superset-depends-on
    volumes: *superset-volumes

Community Discussions

Trending Discussions on incubator-superset
  • No package metadata was found for apache-superset
  • I have mysql and apache superset setup on dockers and connected by a bridge network, what will theSQLAlchemy URI be?
  • Has anyone tried making custom charts with Superset as per preset.io blog?
  • How to configure Celery Worker and Beat for Email Reporting in Apache Superset running on Docker?
  • Terraform: Deploying a Docker Compose app on EKS/ECS
  • how to give individual schema access to users in apache-superset?
Trending Discussions on incubator-superset

QUESTION

No package metadata was found for apache-superset

Asked 2022-Jan-14 at 00:53
(superset) cwj0@ubuntu:~/anaconda3/envs/superset/lib/python3.7/site-packages/incubator-superset$ superset init
Traceback (most recent call last):
  File "/home/cwj0/anaconda3/envs/superset/bin/superset", line 33, in <module>
    sys.exit(load_entry_point('apache-superset', 'console_scripts', 'superset')())
  File "/home/cwj0/anaconda3/envs/superset/bin/superset", line 22, in importlib_load_entry_point
    for entry_point in distribution(dist_name).entry_points
  File "/home/cwj0/anaconda3/envs/superset/lib/python3.7/site-packages/importlib_metadata/__init__.py", line 951, in distribution
    return Distribution.from_name(distribution_name)
  File "/home/cwj0/anaconda3/envs/superset/lib/python3.7/site-packages/importlib_metadata/__init__.py", line 542, in from_name
    raise PackageNotFoundError(name)
importlib_metadata.PackageNotFoundError: No package metadata was found for apache-superset

superset db migrateand superset db upgrade also the same result.What is the reason for this? And how should it be solved?Thanks!

ANSWER

Answered 2022-Jan-14 at 00:53

Solved. Because this is the need to refresh the permissions after I add a new page, I don't know why the dependencies are missing, and the installation is solved.

pip install -r requirements/local.txtpip install -e .

(superset) cwj0@ubuntu:~/anaconda3/envs/superset/lib/python3.7/site-packages/incubator-superset$ pip install -r requirements/local.txt

(superset) cwj0@ubuntu:~/anaconda3/envs/superset/lib/python3.7/site-packages/incubator-superset$ pip install -e .

(superset) cwj0@ubuntu:~/anaconda3/envs/superset/lib/python3.7/site-packages/incubator-superset$ superset init
Loaded your LOCAL configuration at [/home/cwj0/anaconda3/envs/superset/lib/python3.7/site-packages/incubator-superset/superset_config.py]
logging was configured successfully
2022-01-14 08:45:43,385:INFO:superset.utils.logging_configurator:logging was configured successfully
2022-01-14 08:45:43,428:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
Syncing role definition
2022-01-14 08:45:48,268:INFO:superset.security.manager:Syncing role definition
Syncing Admin perms
2022-01-14 08:45:48,296:INFO:superset.security.manager:Syncing Admin perms
Syncing Alpha perms
2022-01-14 08:45:48,538:INFO:superset.security.manager:Syncing Alpha perms
Syncing Gamma perms
2022-01-14 08:45:48,784:INFO:superset.security.manager:Syncing Gamma perms
Syncing granter perms
2022-01-14 08:45:49,031:INFO:superset.security.manager:Syncing granter perms
Syncing sql_lab perms
2022-01-14 08:45:49,270:INFO:superset.security.manager:Syncing sql_lab perms
Fetching a set of all perms to lookup which ones are missing
2022-01-14 08:45:49,498:INFO:superset.security.manager:Fetching a set of all perms to lookup which ones are missing
Creating missing datasource permissions.
2022-01-14 08:45:49,723:INFO:superset.security.manager:Creating missing datasource permissions.
Creating missing database permissions.
2022-01-14 08:45:49,752:INFO:superset.security.manager:Creating missing database permissions.
Cleaning faulty perms
2022-01-14 08:45:49,756:INFO:superset.security.manager:Cleaning faulty perms

Source https://stackoverflow.com/questions/70694733

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install incubator-superset

[See in the documentation](https://superset.incubator.apache.org/docs/installation/installing-superset-using-docker-compose).

Support

Superset speaks many SQL dialects through SQLAlchemy - a Python SQL toolkit that is compatible with most databases. Here are some of the major database solutions that are supported:. <p align="center"> <img src="superset-frontend/images/redshift.png" alt="redshift" border="0" width="106" height="41"/> <img src="superset-frontend/images/google-biquery.png" alt="google-biquery" border="0" width="114" height="43"/> <img src="superset-frontend/images/snowflake.png" alt="snowflake" border="0" width="152" height="46"/> <img src="superset-frontend/images/presto.png" alt="presto" border="0" width="152" height="46"/> <img src="superset-frontend/images/druid.png" alt="druid" border="0" width="135" height="37" /> <img src="superset-frontend/images/postgresql.png" alt="postgresql" border="0" width="132" height="81" /> <img src="superset-frontend/images/mysql.png" alt="mysql" border="0" width="119" height="62" /> <img src="superset-frontend/images/mssql-server.png" alt="mssql-server" border="0" width="93" height="74" /> <img src="superset-frontend/images/db2.png" alt="db2" border="0" width="62" height="62" /> <img src="superset-frontend/images/sqlite.png" alt="sqlite" border="0" width="102" height="45" /> <img src="superset-frontend/images/sybase.png" alt="sybase" border="0" width="128" height="47" /> <img src="superset-frontend/images/mariadb.png" alt="mariadb" border="0" width="83" height="63" /> <img src="superset-frontend/images/vertica.png" alt="vertica" border="0" width="128" height="40" /> <img src="superset-frontend/images/oracle.png" alt="oracle" border="0" width="121" height="66" /> <img src="superset-frontend/images/firebird.png" alt="firebird" border="0" width="86" height="56" /> <img src="superset-frontend/images/greenplum.png" alt="greenplum" border="0" width="140" height="45" /> <img src="superset-frontend/images/clickhouse.png" alt="clickhouse" border="0" width="133" height="34" /> <img src="superset-frontend/images/exasol.png" alt="exasol" border="0" width="106" height="59" /> <img src="superset-frontend/images/monet-db.png" alt="monet-db" border="0" width="106" height="46" /> <img src="superset-frontend/images/apache-kylin.png" alt="apache-kylin" border="0" width="56" height="64"/> </p>. A complete list of supported databases can be found [here](https://superset.incubator.apache.org/docs/databases/installing-database-drivers).

DOWNLOAD this Library from

Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from
over 430 million Knowledge Items
Find more libraries
Reuse Solution Kits and Libraries Curated by Popular Use Cases

Save this library and start creating your kit

Explore Related Topics

Share this Page

share link
Consider Popular Data Visualization Libraries
Compare Data Visualization Libraries with Highest Support
Compare Data Visualization Libraries with Highest Quality
Compare Data Visualization Libraries with Highest Security
Compare Data Visualization Libraries with Permissive License
Compare Data Visualization Libraries with Highest Reuse
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from
over 430 million Knowledge Items
Find more libraries
Reuse Solution Kits and Libraries Curated by Popular Use Cases

Save this library and start creating your kit

  • © 2022 Open Weaver Inc.