Apache Superset Installation (CentOS 7)

In this article, we will install Apache Superset with two different techniques.

Apache Superset is an open source business intelligence web application. Developed by Airbnb with the Python Flask library. There are certain features used in it.

• With SQL Alchemy you can connect to multiple data sources.

• An authorization system can be established by assigning different roles to users.

• Thanks to the built-in SQL Editor, various queries can be made to the connected databases.

• You can use LDAP authentication.

1- Installation with Python

sudo yum install gcc gcc-c++ libffi-devel python-devel python-pip python-wheel openssl-devel cyrus-sasl-devel openldap-devel

We are installing Python3.

yum install python3 

We install the necessary libraries in Python.(Install libraries in the following order.)

pip3 install --upgrade setuptools
pip3 install setuptools_rust
sudo yum install epel-release
python3 -m pip install --upgrade pip
pip3 install cryptography
sudo yum install python3-devel

Installing Superset.

pip3 install apache-superset

We need to install the necessary libraries for Superset.

pip3 install sqlalchemy==1.3.24
pip3 install dataclasses

Installing by running through the following commands.

#Default db setup
superset db upgrade

#The Flask config variable is set to superset.
export FLASK_APP=superset

#User is added manually.
superset fab create-admin 

#Imports sample dashboards, charts and tables for Superset.
superset load_examples

#The privileges are inited.
superset init

We're starting the superset.

superset run -p 8088 --with-threads --reload --debugger

Web Application interface

You can login using hostname:port

localhost:8088

On the screen you see, you can log in with the username and password you created in the command above (superset fab create-admin).

2- Installation with Docker (centOS 7)

First, start by installing Docker.

yum install docker

Then, installing git.

yum install git

We download the Apache Superset to the directory where we want to install it. (Note the directory for permission errors.)

cd /usr/local
git clone https://github.com/apache/superset.git
cd superset

We download Docker compose because we need to install it with Docker compose.

curl -SL https://github.com/docker/compose/releases/download/v2.12.2/docker-compose-linux-x86_64 -o /usr/local/bin/docker-compose

Then we do the authorization process.

sudo chmod +x /usr/local/bin/docker-compose

Starting docker.

systemctl start docker

Make sure you are in the Apache Superset installation directory. Now we are launching our application.

docker-compose -f docker-compose-non-dev.yml pull
docker-compose -f docker-compose-non-dev.yml up

Web Application interface

You can login using hostname:port

localhost:8088

Default

username: admin

password: admin

you can login.

In this article, we have installed Apache Superset with you with two different techniques.

You can support us by liking and sharing the article.

Hope to see you in new posts..