visualization

Data visualization with Superset and Metabase

Tech Stack

• Apache Superset
• Metabase Open Source
• Docker

Up & Running

Superset

0. (Optional) Pre-loaded examples (demo charts/dashboards):

Superset can be bootstrapped withexample charts and dashboards. In order to enable that, set:

export SUPERSET_LOAD_EXAMPLES=yes

Make sure to: unset SUPERSET_LOAD_EXAMPLES or export SUPERSET_LOAD_EXAMPLES=no after the first run of superset-init is completed successfully, as load_examples alone can take a few minutes.

1. Spin up Apache Superset infrastructure with:

docker compose -f compose.superset.yaml up -d

2. Additional database drivers:

Superset supports PostgreSQL, MySQL and out-of-the-box. To enable additional data sources, include the respective SQLAlchemy driver as a dependency in requirements-local.txt.

A complete list of supported data sources can be found here.

sqlalchemy-bigquery==1.11.0
sqlalchemy-redshift==0.8.14
clickhouse-connect==0.7.16

3. After the superset-app container is in a healthy state, you can acccess Superset at:

open http://localhost:8088/

Metabase

1. Spin up Metabase infrastructure with:

docker compose -f compose.metabase.yaml up -d

2. Additional database drivers:

Metabase supports a wide-variety of data sources out-of-the-box (BigQuery, RedShift, Snowflake, Spark SQL, Druid, PostgreSQL, MySQL, among others). The complete list of supported data sources can be found here.

For Partners Data Sources and Community Data Source connectors, such as ClickHouse, however, additional JDBC drivers have to be downloaded and put in the plugins folders, which is exactly what the metabase-init container is for.

3. After the metabase-app container is in a healthy state, you can acccess Metabase at:

open http://localhost:3000/

TODO:

• Bootstrap Apache Superset infrastructure in Docker
• Bootstrap Metabase infrastructure in Docker
• Build data viz for NYC Taxi Dataset on Superset
• Build data viz for NYC Taxi Dataset on Metabase