After service installation is complete and Ambari reports the service as healthy, users should be able to access the Superset web interface through the URL exposed by the Quicklinks under Actions.
Metadata Database Support
Superset uses a metadata database to store its own internal application state, including saved charts, dashboards, datasets, database connections, and other configuration data.
According to the upstream Superset guidance:
SQLite is useful for getting started, but it is not recommended for production deployments
PostgreSQL is a supported production metadata database option
MySQL is also a supported production metadata database option
In production environments, the metadata database should be treated as a core service dependency and planned with the same care as other persistent platform services, including backup, recovery, upgrades, and access control.