Superset
BUSINESS INTELLIGENCE
Apache Superset is an open-source data exploration and visualization platform designed for modern data teams. It offers a rich set of data visualization capabilities, a user-friendly interface, and robust integration options for various data sources. Superset allows users to create and share dashboards, run SQL queries, and gain insights from their data in real-time.
Superset + MotherDuck
Superset integrates with MotherDuck by connecting to it as a SQL-based data source. Users can configure Superset to query data stored in MotherDuck's cloud data warehouse, leveraging DuckDB's efficient query processing engine. This integration enables seamless data visualization and exploration directly from MotherDuck within the Superset interface.
MotherDuck also supports Preset, which is a commercial cloud platform based on the Apache Superset open source project.
FAQS
How do I connect Apache Superset to MotherDuck?
First, install the required Python packages in your Superset environment: duckdb-engine, duckdb, and flask_appbuilder. Then access the Superset UI, navigate to Settings → Database Connections, select 'MotherDuck' from the database dropdown, enter your database name and MotherDuck token, test the connection, and save. See our Superset documentation for detailed setup steps.
Can I use Preset with MotherDuck?
Yes, Preset (the managed cloud version of Apache Superset) has direct MotherDuck integration. Create a Preset account (free tier supports up to 5 users), then from Settings → Database Connections, click '+ Database', select MotherDuck, and enter your credentials with the database name prefixed as md: along with your access token.
What packages do I need to connect Superset to DuckDB?
You need three Python packages: duckdb-engine (version 0.17.0+), duckdb (version 1.2.2+), and flask_appbuilder (version 4.6.3+). Add these to your superset/docker/requirements-local.txt file, then rebuild your containers with docker-compose up --build.
Should I use Superset or Preset with MotherDuck?
Preset is easier to set up since it's fully managed and has built-in MotherDuck support—great for teams wanting quick deployment. Self-hosted Apache Superset gives you more control and customization options but requires managing your own infrastructure. For production systems, use a dedicated service account token rather than auto-generated tokens.
