Skip to content

Latest commit

 

History

History
41 lines (31 loc) · 1.32 KB

SUPERSET.md

File metadata and controls

41 lines (31 loc) · 1.32 KB

Experiements with Apache Superset

I have added Superset to the existing Airflow stack in Docker-compose and there i have been able to visualize the data thats been ingested via airflow DAGS. Here is a simple chart that I created This chart provides the total tests done in Albany county per day and the new positives identified that day.

covid-master-2021-02-23T01-43-21 230Z

Instructions to setup Superset

Once the instructions to start Airflow is complete, follow the below steps:

  • Connect to the superset container.
docker exec -it airflowdocker_superset_1 /bin/bash
  • Create user in superset
superset fab create-admin --username admin --firstname superset --lastname Admin --email [email protected] --password XXXX
  • Upgrade superset db
superset db upgrade
  • Superset init
superset init

  • Access superset ui at localhost:8090 and login using credentials set above

  • Add Database connection. Connection string would be as below:

postgresql://airflow:XXXXXXXXXX@postgres:5432/userdata

image

TODO

  • Create a script for the above steps and automate user creation in superset