Skip to main content

Superset

What it is. A BI and dashboarding platform (Apache Superset chart 0.15.5, appVersion 5.0.0).

Why stardelt uses it. Superset provides interactive dashboards and SQL Lab over the data platform, using Trino as its query engine.

How it fits. Superset lives in the application layer and queries Trino via the SQLAlchemy Trino driver. It signs in through the platform IdP (Keycloak) and is consumed by users for dashboards and ad hoc SQL. See Services and How it works.

Who can use it. Users sign in at https://superset.<base domain> with the same Keycloak account used for Nova. stardelt-admins map to Superset Admin; stardelt-users map to Gamma and stardelt-analyst. Per-group catalog access is granted via roles stardelt-group-<group> created by manifests/superset-group-roles.yaml (cron every 5 min) based on Catalog grants; roles sync at login (AUTH_ROLES_SYNC_AT_LOGIN). See Dashboards and SQL Lab.

What you can tune. Key settings from helm-values/superset.yaml:

SettingValues fileKeyDefaultWhat it changes
Superset imagehelm-values/superset.yamlimage.repository / image.tagghcr.io/stardelt/superset / dev@sha256:b9ced85d81a0c9efd2ca993f27bba5470e4815aad9d246b93e3ca5e62d26e8cdStardelt Superset image with drivers pre-installed.
Image pull secrethelm-values/superset.yamlimagePullSecrets[{"name": "ghcr-creds"}]Pull secret for private image.
Service accounthelm-values/superset.yamlserviceAccountNamesupersetSA used by pods and init Jobs for group role sync.
Bootstrap scripthelm-values/superset.yamlbootstrapScript(inline script)Startup bootstrap behavior.
Iframe embeddinghelm-values/superset.yamlconfigOverrides.iframe_embeddingTALISMAN_ENABLED=FalseAllows embedding in Nova (MVP).
Init configurationhelm-values/superset.yamlinit(see values)Init jobs/config for Superset setup.
Superset nodehelm-values/superset.yamlsupersetNode(see values)Web node configuration.
Superset workerhelm-values/superset.yamlsupersetWorker(see values)Celery worker configuration.
Metadata DBhelm-values/superset.yamlpostgresql.enabledtrueBundled PostgreSQL for Superset metadata.
Redishelm-values/superset.yamlredis.enabledtrueBundled Redis for caching/celery.

What it replaces. Superset replaces a standalone BI server over a warehouse with a platform-integrated dashboarding tool.

Operating it.

  • Health check: kubectl -n stardelt get pods -l app.kubernetes.io/name=superset
  • Logs: kubectl -n stardelt logs -l app.kubernetes.io/component=superset -n stardelt
  • Install step: make step-superset (from stardelt-platform)
  • Backup: App database dump via manifests/pg-dump-backup.yaml / make step-pgdump (Superset metadata DB)