数据可视化研究superset-安装

1. 克隆

git clone https://github.com/amancevice/docker-superset.git

2. 安装 (examples下的README.md文件)

Superset Examples

Example configurations for MySQL, PostgreSQL, SQLite, and Celery are provided, along with a simple demo script for starting them.

Each demo provides a superset_config.py and a docker-compose.yml. Use these as guides for laying down your own instances.

Start a demo of Superset using the demo.sh script. The script takes a single argument that determines the back end for Superset: sqlite, mysql, postgres, or celery.

bash demo.sh mysql|postgres|sqlite|celery //会设置登录的账号和密码

You will be prompted to set up an admin user.

When finished navigate to http://localhost:8088/ to see the demo.

Log in with the credentials you just created.

The demo will live for 5 minutes and then be brought down.

Here is a more detailed explanation of what the demo script is doing:

MySQL

cd mysql

# Start Redis & MySQL services
docker-compose up -d redis mysql
# Wait for services to come up fully...

# Start Superset
docker-compose up -d superset
# Wait for Superset to come up fully...

# Initialize Superset DB
docker-compose exec superset superset-demo
# or `docker-compose exec superset superset-init` if no demo data needed

# Play around in demo...

# Bring everything down
docker-compose down -v

PostgreSQL

cd postgres

# Start Redis & PostgreSQL services
docker-compose up -d redis postgres
# Wait for services to come up fully...

# Start Superset
docker-compose up -d superset
# Wait for Superset to come up fully...

# Initialize demo
docker-compose exec superset superset-demo
# or `docker-compose exec superset superset-init` if no demo data needed

# Play around in demo...

# Bring everything down
docker-compose down -v

SQLite

cd sqlite

# Start Redis service
docker-compose up -d redis
# Wait for services to come up fully...

# Touch SQLite db file
mkdir -p superset
touch superset/superset.db

# Start Superset
docker-compose up -d superset
# Wait for Superset to come up fully...

# Initialize demo
docker-compose exec superset superset-demo
# or `docker-compose exec superset superset-init` if no demo data needed

# Play around in demo...

# Bring everything down
docker-compose down -v

Celery

cd celery

# Start Redis & PostgreSQL services
docker-compose up -d redis postgres
# Wait for services to come up fully...

# Start Superset
docker-compose up -d superset
# Wait for Superset to come up fully...

# Start Celery worker
docker-compose up -d worker

# Initialize demo
docker-compose exec superset superset-demo
# or `docker-compose exec superset superset-init` if no demo data needed

# Play around in demo...

# Bring everything down
docker-compose down -v

database dependencies plugins

#
# This file is created for superset database dependencies plugins
#
mysqlclient==1.3.13                 # MySQL         mysql://
cx_Oracle==7.0.0                    # Oracle        oracle://
snowflake-sqlalchemy==1.1.6         # Snowflake     snowflake://
sqlalchemy-redshift==0.7.2          # Redshift      redshift+psycopg2://
pymssql==2.1.4                      # MSSQL         mssql://
impyla==0.14.1                      # Impala        impala://
PyAthenaJDBC==2.0.1                 # Athena        awsathena+jdbc://
PyAthena==1.4.4                     # Athena        awsathena+rest://
sqlalchemy-vertica-python==0.4.3    # Vertica       vertica+vertica_python://
sqlalchemy-clickhouse==0.1.5.post0  # ClickHouse    clickhouse://
kylinpy==2.1.2                      # Kylin         kylin://
pybigquery==0.4.8                   # BigQuery      bigquery://
sqlalchemy-teradata==0.9.0.dev0     # Teradata      teradata://
psycopg2==2.7.6.1                   # Postgres, Greenplum       postgresql+psycopg2://
PyHive==0.6.1                       # Presto  presto://, Hive    hive://, SparkSQL    jdbc+hive://
pinotdb==0.2.3                      # PintoDB
elasticsearch-dbapi==0.1.2
gsheetsdb==0.1.9
cockroachdb==0.3.3
pydruid==0.5.9
#
# Optional packages
#
flower==0.9.2
tornado==5.1.1            # via flower
thrift-sasl==0.3.0
thrift==0.11.0
sasl==0.2.1               # via thrift-sasl
boto3==1.4.7
botocore==1.7.48
docutils==0.14            # via botocore
jmespath==0.9.3           # via boto3, botocore
s3transfer==0.1.13        # via boto3

Posted on Sep 06, 2020


评论:

请登录 登录 评论!