Superset is a leading open-source tool for data exploration and visualization, enabling users to dive deep into datasets and extract meaningful insights. For those seeking a managed Superset experience, Preset provides a hassle-free, fully-managed Superset service.
Synmetrix, with its robust SQL API, allows for a straightforward connection to Apache Superset, making it easy to visualize data managed by Synmetrix.
Connecting Apache Superset to Synmetrix treats Synmetrix as a PostgreSQL database, thanks to the SQL API provided by Synmetrix. This approach simplifies the integration process, enabling users to quickly set up and start visualizing their data.
Ensure the following software is installed before proceeding:
Clone this repository:
git clone https://github.com/mlcraft-io/examplesand navigate to the superset folder:
cd examples/superset- Start Synmetrix and Superset using Docker Compose provided in this directory. Run the following command to start the services:
./1-start-containers.shBefore proceeding, ensure you have gone through the Synmetrix Quick Start guide.
Synmetrix provided with seed data for the demo purposes.
- Set up the Superset database, users, and roles:
./2-setup-superset.shThe default credentials are admin for both username and password. Feel free to modify these as needed.
Wait until the services are up and running. You can check the status of the services using the following command:
./3-show-logs.shNOTE: to stop the services and remove volumes, run the following command:
./4-stop-containers.sh-
Go to:
http://localhost:9999 -
In Apache Superset, navigate to Settings -> Database Connections and choose + Database to add a new database connection. Use the Synmetrix SQL API credentials for configuration:
Use the following credentials to configure the connection:
| Host | Port | Database | User | Password |
|---|---|---|---|---|
| synmetrix | 15432 | db | demo_pg_user | demo_pg_pass |
After establishing the connection, Synmetrix's data models become accessible as tables in Superset. This allows users to create datasets and design charts using Synmetrix's structured data models. For example, consider a data model for "orders":
cubes:
- name: orders
sql: SELECT * FROM orders
measures:
- name: count
sql: COUNT(*)
type: count
dimensions:
- name: status
sql: status
type: string
- name: created_at
sql: created_at
type: timeThis configuration enables the orders table to be used in Superset for creating insightful visualizations, leveraging measures and dimensions defined in Synmetrix for comprehensive data analysis.
By connecting Synmetrix to Apache Superset, users gain the ability to visualize and interact with their data in a powerful and intuitive manner, enhancing data-driven decision-making processes across the organization.
