apache-superset

This repository holds the Dockerfile image used to build the Apache Superset application currently available the DeltaV Edge Applications Marketplace. Apache Superset is a modern, enterprise-ready business intelligence web application for data exploration and visualization. It provides a rich set of tools to turn data into meaningful insights through interactive dashboards and reports.

Features

• No-Code Interface: Build charts and dashboards quickly without needing to write code.
• Web-Based SQL Editor: Advanced querying capabilities with a powerful SQL editor.
• Diverse Visualizations: Supports a wide array of visualizations, from simple bar charts to complex geospatial charts.
• Lightweight Caching: Configurable caching layer to enhance performance and responsiveness.
• Extensible Security: Highly extensible security roles and authentication options.
• Cloud-Native Architecture: Designed for scalability and robust performance in cloud environments.
• Interactive Queries: Allows interactive querying and previewing of results.

Uses

• Data Exploration: Explore and visualize data from various sources.
• Business Intelligence: Create interactive dashboards for business insights.
• Real-Time Analytics: Analyze real-time data streams for immediate insights.
• Reporting: Generate and share detailed reports with stakeholders.
• Geospatial Analysis: Visualize and analyze geospatial data.
• Data Integration: Consolidate data from multiple sources into a single view.
• Security Monitoring: Monitor and control access to sensitive data.
• Collaborative Analysis: Facilitate collaborative data analysis and decision-making.

Prerequisites

1. You must have Apache Superset installed from the marketplace.
2. Apache Superset needs a database URI for SQLAlchemy (one of its running libraries) as well as a rate limit storage URI. For these, PostgreSQL (EmersonDeltaV/postgresql) and Redis (EmersonDeltaV/redis) fits these URI needs respectively. Both are also available in the Edge Applications Marketplace.
3. Apache Superset also needs a secret key for security purposes. Use whatever available key generator you have.

Apache Superset Setup

This setup example is used to visualize an SQL database available in your edge node (PostgreSQL for now). Apache Superset can be used as a visualizer and chart creator for other applications present in your edge node.

1. Launch the Apache Superset Web Interface: http://{edge_ip}:8088. The default username is edge_admin and the default password is Emerson#123.
2. To begin, add a database to Apache Superset. In the upper right corner, click the "+" icon. Select "Data" and "Connect database" to open the interface in adding a database.
   
3. Follow the onscreen instructions to add an SQL based database to query on.
4. In the uppper-left corner, select the "SQL" tab and start a query. In the "DATABASE" dropdown in the screenshow below, the database you just added should appear here, along with the schemas available on the database. To add more databases, go to "Settings" in the upper right corner and click on "Database Connections" on the dropdown to view all active database connections as well as the option to add a new one.
   
5. To create charts, click on the "Charts" tab on the upper left corner. Make sure to reference the database you connected to view the schemas properly.
   

Changelist

• 04/22/2025 - First version.