SuperSet实战

整合MySQL数据源

1. root登录后切换到itbaizhan，并激活superset环境

   xxxxxxxxxx
   [root@node4 ~]# su itbaizhan
   [itbaizhan@node4 root]$ cd
   [itbaizhan@node4 ~]$ conda activate superset
   (superset) [itbaizhan@node4 ~]$ 
   

   如果当前状态为(superset) [itbaizhan@node4 ~]$则忽略此步。

2. 安装MySQL依赖

   xxxxxxxxxx
   (superset) [itbaizhan@node4 ~]$ conda install mysqlclient
   

   注：对接不同的数据源，需安装不同的依赖，以下地址为官网说明：

   https://superset.apache.org/docs/databases/installing-database-drivers/

   Database	PyPI package	Connection String
   Apache Drill	pip install sqlalchemy-drill	drill+sadrill:// For JDBC drill+jdbc://
   Apache Druid	pip install pydruid	druid://<User>:<password>@<Host>:<Port-default-9088>/druid/v2/sql
   Apache Hive	pip install pyhive	hive://hive@{hostname}:{port}/{database}
   Apache Impala	pip install impyla	impala://{hostname}:{port}/{database}
   Apache Kylin	pip install kylinpy	kylin://<username>:<password>@<hostname>:<port>/<project>?<param1>=<value1>&<param2>=<value2>
   Apache Spark SQL	pip install pyhive	hive://hive@{hostname}:{port}/{database}
   ClickHouse	pip install clickhouse-sqlalchemy	clickhouse+native://{username}:{password}@{hostname}:{port}/{database}
   Elasticsearch	pip install elasticsearch-dbapi	elasticsearch+http://{user}:{password}@{host}:9200/
   IBM Db2	pip install ibm_db_sa	db2+ibm_db://
   MySQL	pip install mysqlclient	mysql://<UserName>:<DBPassword>@<Database Host>/<Database Name>
   Oracle	pip install cx_Oracle	oracle://
   SQLite	No additional library needed	sqlite://
   SQL Server	pip install pymssql	mssql://

3. 重启superset

   xxxxxxxxxx
   (superset) [itbaizhan@node4 ~]$ ./superset.sh restart
   restart Superset!!
   superset is stop
   

4. 登录superset WebUI：http://node4:8787/login/

5. 点击Data->Databases

   

6. 点击 +DATABASE

   

7. 选择MySQL并点击

   

8. 填写连接信息

   方式一

   

   方式二

   

   点击TEST CONNECTION，出现“Connection looks good!”提示即表示连接成功

9. 点击上图的CONNECT