Apache Superset / Preset

Apache Superset is an open-source modern data exploration and visualization platform, written in Python.

Preset offers a managed, elevated, and enterprise-grade SaaS for open-source Apache Superset.

Managed Superset

Preset Cloud is a fully-managed, open-source BI for the modern data stack, based on Apache Superset.

  • Hassle-free setup: There is no need to install or maintain software with Preset. Get the latest version of Superset in a secure, reliable, and scalable SaaS experience.

  • Up-to-date Superset, always: Access all the latest features of Superset released and thoroughly tested every two weeks.

  • One-click to deploy multiple workspaces: Give each team in your organization a separate Superset workspace to protect sensitive data.

  • Control user roles and access: Easily assign roles and fine-tune data access using RBAC and row-level security (RLS).

Install

Follow the steps in how to install database drivers in Docker Images to install the CrateDB connector package when setting up Superset locally using Docker Compose.

echo "sqlalchemy-cratedb" >> ./docker/requirements-local.txt

Connect

Use a suitable SQLAlchemy connection string matching your environment. When connecting to CrateDB Self-Managed on localhost, for evaluation purposes, use:

crate://crate@127.0.0.1:4200

When connecting to CrateDB Cloud, use:

crate://<username>:<password>@<clustername>.cratedb.net:4200/?ssl=true

Learn

Tutorials

Development

Webinars

Apache Superset 101

From connecting databases to building charts, dashboards, and interactive filters, this video educates about at all the basic surfaces and workflows of Apache Superset.

 

Webinar Fundamentals

Apache Superset and CrateDB: Introduction to Time-Series Visualization

In this webinar, we will discuss how to use different visualization options in Superset coupled with a SQL interface to derive interesting insights and findings from the time-series dataset.

 

Webinar Integrations

See also

CrateDB and Superset