Apache Superset #
You can use Apache Superset™ as well as the hosted cloud service Preset Cloud with Starburst Galaxy, Starburst Enterprise platform (SEP), and Trino to explore and visualize your data. Superset is a data exploration and visualization web application. It is typically run on a server and used by many users accessing the application. It enables users to write SQL queries, create new tables, visualizations and dashboards, and download data into files.
Requirements #
Apache Superset has built-in support for Starburst Galaxy and SEP.
Versions 350-e and higher can use the preferred mechanism of a Trino connection. It is powered by the SQLAlchemy driver and allows full usage of SQL as supported by Trino.
Older versions use the legacy presto:// protocol with the presto
connection. It uses the
PyHive driver and therefore does not support
all supported SQL syntax.
Connection #
Get the necessary connection information for your cluster:
- Username
- Password
- Host
- Port
Superset understands the concept of catalogs. You can create a connection with or without a specified catalog:
- trino://{username}:{password}@{hostname}:{port}/{catalog}
- trino://{username}:{password}@{hostname}:{port}
Once you have gathered this information, you can create a new connection in Superset:
- Select Data > Databases, and click the + Database button.
- Enter the connection string formed from your connection information.
- Test the connection, if desired.
- Click Add.
/ between the username and role value to be URL encoded with
%2F. A username in the form username@example.com/accountadmin must be
entered as username@example.com%2Faccountadmin.TLS/HTTPS #
Any cluster that requires authentication is required to use TLS/HTTPS. If the best practice of using a globally trusted certificate is implemented, you can use the HTTPS URL of the cluster in the connection string.
If the certificate is not globally trusted, you must configure the SEP certificate for TLS/SSL access from Superset on the Superset server.
Authentication #
You can configure the same authentication provider for Superset and SEP. As a result, the same credentials can be used to log in to either system.
Authentication providers supported by both systems include LDAP and OAuth2:
Resources #
- Apache Superset website.
- Apache Superset documentation
- Preset: A powerful, easy to use data exploration and visualization platform, powered by Apache Superset.
- Trino Community Broadcast interview with the Apache Superset team, including live demo
Is the information on this page helpful?
Yes
No