Apache Superset - My experience and common issues I have faced

In this blog I don’t want to mention about what is Apache Superset and what it does , the documentation of Apache Superset is good enough for it. Here I just want to share what are the issues I have occurred while using Apache Superset.

Running Superset locally :-

You can run Superset in your local machine in many ways but the most easier way is by running through docker.

   git pull  https://github.com/apache/superset.git

   git checkout 1.3.0

Here in the place of 1.3.0 you can checkout any other stable release version.

We can run Apache Superset with docker-compose. The command to run is

docker-compose -f docker-compose.yml up -d

There will be two docker-compose files in Apache Superset , docker-compose and docker-compose-non-dev. If you want to make changes in the code and you want to see how the changes are reflected in the Superset then you need to run the Superset using docker-compose file or else you can run the Superset using docker-compose-non-dev.

After running the Superset if you want to see the logs of the superset run the below command.

   docker logs -f superset_app 

After running the docker-compose file sometimes your front-end assets generation will take a lot of time and while opening superset in the browser you can see a blank screen , so don’t worry if you see such screen just make sure to wait for some time and this issue happens a lot when you are running Apache Superset for the first time.

To check the progress of the front-end assets generation just see the logs in the superset_node container and you can see when the assets generation has been completed.

Common UseCases :-

1. Importing and Exporting Charts and Dashboards :-

Suppose you have superset in your dev or staging environment and you have to migrate dashboards and charts to the supeset in production environment , then exporting and importing of charts and dashboards is one of the best method.

To enable the Importing and Exporting feature you have to enable the below flag in the config.py file and then re-run the superset.

 VERSIONED_EXPORT = True

2. Access for Dashboards and Charts :-

To provide read-only access of charts for the users , first you need to provide the dataset access to that particular role which the user has.If you provide the dataset access to a particular role for example Gamma role then all the users who has the Gamma role can view the chart which was visualized on the basis of that dataset.

If you want to provide the edit access of the chart for an user then you have to add the user to the owner's section in that particular chart.You can do this by going to charts section and click on the edit button on a particular chart and in the owner's section you can add the user.