Apache Superset with Existing Postgresql Instance

Digital engineer working on virtual blueprint building
Reading Time: < 1 minute

In this blog, we will learn to deploy & set up Apache Superset with PostgreSQL instance. Apache Superset is an open-source software application for data exploration and data visualization able to handle data at a petabyte scale. 


  • A Postgresql Instance deployed on the same Kubernetes cluster
  • Helm installed in system & basic knowledge of Helm.
  • Admin username & password of PostgreSQL instance
  • Superset Database created in PostgreSQL (If not then follow step 2)
  • Optionally Cert-manager if you want to have SSL certificates on hostnames.

Before You Begin

Clone the repo for scripts & code then change the directory to the cloned repo.

git clone https://github.com/knoldus/deploy-apache-superset.git
cd deploy-apache-superset

Steps to deploy

1. Create or Edit apache-superset/custom-values.yaml file

Replace placeholders with username, password and service name.

    ## Changes to service name of your postgresql instance
    db_host: <POSTGRES_SERVICE_NAME>.<NAMESPACE>.svc.cluster.local
    db_port: "5432"
    ## change the <USERNAME> with admin username of postgres 
    db_user: <USERNAME>
    ## change the <PASSWORD> with admin username of postgres
    db_pass: <PASSWORD>

2. Create database in postgresql (If not created)

kubectl port-forward service/<SERVICE_NAME_OF_POSTGRES> 5432
createdb -h -p 5432 -U <USERNAME> superset

3. Add ingress configs values

In Values.ingress add values

  enabled: true
  ingressClassName: nginx
  path: /
  pathType: ImplementationSpecific
   - secretName: <SECRET_NAME_OF_CERT_KEYS>
       - <YOUR_HOST_NAME>

3. Deploy Apache superset

helm upgrade --install superset apache-superset -f apache-superset/custom-values.yaml --namespace superset --create-namespace


This is how we can deploy Apache Superset with an already existing PostgreSQL instance.

For more interesting blogs checkout Knoldus blogs site

More Blogs from Rahul Soni

Written by 

Rahul Soni is a Software Consultant at Knoldus Software. He is always charged up for new things & learnings. He is dedicated to his work and believes in quality output. He loves to take deep dives into cloud technologies & different tools.