Features, use cases, and support

Dell Data Analytics Engine, powered by Starburst Enterprise platform (SEP) is a commercial distribution of Trino. Starburst Enterprise includes the Trino cost-based optimizer as well as additional security features, more connectors, support for using additional deployment platforms, and much more.

• Use cases
• Core concepts

Starburst Enterprise

A number of enterprise features require a license key to be enabled. For more information about obtaining and installing a license, see Starburst Enterprise license.

The feature lists in this topic are designed to help you understand the similarities and differences between open source Trino, and SEP across several categories: platform, deployment scenarios, management, clients, security, support, and connectors.

SEP and Trino feature comparisons

SEP adds many exclusive features to the already-powerful Trino distributed query engine.

Management and administration

Comparison of Trino and SEP support management features

Feature	Trino	Starburst Enterprise
Starburst Enterprise web UI		check_circle_outline
Monitoring with JMX	check_circle_outline	check_circle_outline
High availability		check_circle_outline
Autoscaling with graceful scaledown		check_circle_outline
Backend service (Required)		check_circle_outline
Telemetry		check_circle_outline
Cluster metrics dashboard (Starburst Insights)		check_circle_outline
Data products		check_circle_outline
Apache Atlas integration		check_circle_outline

Note

SEP includes Starburst Admin for customers deploying to on-prem or virtual infrastructure. Starburst Admin is a collection of Ansible playbooks for installing and managing Starburst Enterprise or Trino clusters.

Connectors

SEP contains many additional connectors, as well as improvements of Trino connectors to increase performance, add security features and others. A detailed feature comparison is available in the Starburst connectors feature matrix.

Clients

Clients are anything that connects to Trino or SEP to enable users of that tool to run SQL queries.

For more information about connectors and related extensions, see Starburst connectors feature matrix.

Comparison of Trino and SEP clients

Client	Trino	Starburst Enterprise
Command line interface	check_circle_outline	check_circle_outline
JDBC driver	check_circle_outline	check_circle_outline
Query editor		check_circle_outline

Starburst also supports tools such as Tableau and others.

Security

All security features require a license. For a full list of security documentation, see Security.

Comparison of Trino and SEP security features

Feature	Trino	Starburst Enterprise
Kerberos support	check_circle_outline	check_circle_outline
Kerberos credential passthrough		check_circle_outline
Kerberos support with caching		check_circle_outline
LDAP authentication	check_circle_outline	check_circle_outline
Secrets	check_circle_outline	check_circle_outline
Encryption - secure internal communication	check_circle_outline	check_circle_outline
User impersonation	Hive only	check_circle_outline
Password credential passthrough		check_circle_outline
Backend service		check_circle_outline
Query audit		check_circle_outline
Built-in access control		check_circle_outline
Okta authentication		check_circle_outline

Support

Trino is supported by an active community. Starburst Enterprise adds extensive professional support.

Comparison of Trino and SEP support availability

Feature overview	Trino	Starburst Enterprise
Online community interaction	check_circle_outline	check_circle_outline
24x7 support, 365, under 30 minute SLA		check_circle_outline
Largest team of Trino experts in the world		check_circle_outline
Dedicated technical account manager		check_circle_outline
Fully tested, stable releases, curated by the Trino creators		check_circle_outline
Hot fixes and security patches		check_circle_outline
Long Term Support (LTS) releases		check_circle_outline
Short Term Support (STS) releases with newest features		check_circle_outline

Trino

Trino (formerly PrestoSQL) is a distributed SQL query engine designed to query large datasets distributed over one or more heterogeneous data sources.

Trino is maintained by the large community of contributors and users of the Trino Software Foundation.

Trino: The Definitive Guide

Enjoy a free copy of Trino: The Definitive Guide from Starburst to learn much more about Trino!