Superset init tutorial

creating yandex cloud VM

yc compute instance create \
    --name superset-node \
    --ssh-key ~/.ssh/id_rsa.pub \
    --create-boot-disk image-folder-id=standard-images,image-family=ubuntu-2004-lts,size=100,auto-delete=true \
    --network-interface subnet-name=default-ru-central1-a,nat-ip-version=ipv4 \
    --memory 16G \
    --cores 4 \
    --zone ru-central1-a \
    --hostname superset-node

installing Docker (source)

# Add Docker's official GPG key:
sudo apt-get update
sudo apt-get install ca-certificates curl
sudo install -m 0755 -d /etc/apt/keyrings
sudo curl -fsSL https://download.docker.com/linux/ubuntu/gpg -o /etc/apt/keyrings/docker.asc
sudo chmod a+r /etc/apt/keyrings/docker.asc

# Add the repository to Apt sources:
echo \
  "deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/ubuntu \
  $(. /etc/os-release && echo "$VERSION_CODENAME") stable" | \
  sudo tee /etc/apt/sources.list.d/docker.list > /dev/null
sudo apt-get update

sudo apt-get install docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin

initiating Superset via Docker (source)

sudo docker pull apache/superset
sudo docker run -d -p 8080:8088 -e SUPERSET_SECRET_KEY="your_secret_key_here" --name superset apache/superset

Note: you MUST set a secret key in the envvar SUPERSET_SECRET_KEY in order to start the container!

openssl rand -base64 42

Initialize a local Superset Instance

sudo docker exec -it superset superset fab create-admin \
          --username admin \
          --firstname Superset \
          --lastname Admin \
          --email admin@superset.com \
          --password admin

sudo docker exec -it superset superset db upgrade
sudo docker exec -it superset superset load_examples
sudo docker exec -it superset superset init

initiating Superset via git and Docker

git clone https://github.com/apache/superset.git
cd superset
git checkout 2.1.3
git status

sudo nano docker-compose-non-dev.yml # -> change tag to 2.1.3
sudo docker compose -f docker-compose-non-dev.yml up

password and login - admin

connecting Clickhouse to Superset

sudo docker ps
sudo docker exec -it <container_id> /bin/bash

pip install clickhouse-sqlalchemy # or pip install clickhouse-connect. Check error logs if appear
exit

sudo docker restart <container_id>

Connection string to add new Clickhouse - clickhouse+native://login:password@host:9000/ or clickhousedb://{username}:{password}@{hostname}:{port}/{database}