Case Study: CrateDB enhances Apache Superset database connectivity with Preset

CrateDB builds database connectors for Superset with Preset in 5 minutes

Preset, a company providing services and support for Apache Superset, worked with CrateDB, a relational time series database focused on IoT use cases. CrateDB's challenge was enabling seamless integration with the Superset BI platform to allow its users to leverage Superset's powerful no-code visualization builder and SQL IDE for their time series data.

Preset implemented a solution by guiding the development of a custom database connector for Superset. This involved utilizing the CrateDB team's existing SQLAlchemy-compliant Python library and writing specific database engine code to handle features like time grain conversions. The result was a fully integrated connector that enabled CrateDB users to immediately point Superset to their data stores and start building charts, providing a thin, flexible analytics layer over their existing data infrastructure.

CrateDB