Starburst connectors feature matrix#

The Starburst Enterprise platform (SEP) includes numerous connectors. They can be separated into three categories:

Exclusive connectors enable access to more data sources, and are only available with SEP:

Improved connectors extend the open source Trino connectors with performance improvements, security features and other addons:

Community connectors are the same as the connectors available from the open source Trino project. Starburst provides support for the Black Hole, JMX, Memory, System, TPCDS and TPCDH utility connectors. Support is available through the Trino community for all others.

The following sections provide details about all these connectors and and their key features.

Connector functionality#

The connector functionality tables below shows the different features available for Trino and SEP connectors.

Legend of the feature labels used in the connector overview tables#

Label/symbol

Description

check_circle_outline

Connector is available for Trino

not_interested

Connector is only available with SEP, not available with Trino

identical

Connector included in SEP is identical to the Trino connector.

license required

Connector requires a license. All connectors are included in SEP, and some can be used without a license.

no license required

Connector is available with SEP, includes enhancements, and usage does not require a license.

licensed add-ons

Connector is available with SEP, includes enhancements, and license is required to activate these additional features and performance enhancements.

parallelism

Connector distributes query processing across workers, and uses many connections to the data source at the same time for increased overall performance

table statistics

Connector includes support for table statistics that can be used by the cost-based optimizer for increased query processing performance

managed statistics

Connector includes support for managed statistics that can be used by the cost-based optimizer for increased query processing performance

pushdown

Connector supports pushdown, dynamic filtering and related performance improvements, the label (enhanced) means that additional pushdown features are included with SEP

dynamic row filtering

Connector uses dynamic filters to remove unnecessary rows during a table scan.

user impersonation

Connector supports User impersonation

Kerberos authentication

Connector supports Kerberos authentication

Kerberos credential pass-through

Connector supports pass-through of Kerberos authentication credentials to the underlying data source

password credential pass-through

Connector supports pass-through of password authentication credentials to the underlying data source

OAuth 2.0 token pass-through

Connector supports pass-through of OAuth 2.0 access tokens to the underlying data source

JWT pass-through

Connector supports pass-through of JSON Web Tokens to the underlying data source

AWS IAM authentication

Connector supports Amazon IAM authentication and policy management

NTLM authentication

Connector supports NTLM authentication

If a feature, such as pushdown is mentioned in the Trino and the SEP column, this means that some pushdown support is available with Trino, while SEP includes further improvements.

Additional features, beyond the listed ones, are described with short, italicized names and detailed in the relevant connector documentation.

Distributed object storage connectors#

Distributed object storage system include proprietary systems such a BigQuery or Delta Lake, as well as many object storage or cloud data storage systems, such as S3 and compatible systems. These are often using the Hive connector.

Use the label list and and other information to read the table content.

Features of connectors for distributed object storage systems#

Connector name

Trino key features

SEP key features or extensions

Starburst Delta Lake connector

../_images/delta-lake.png

check_circle_outline

  • parallelism

  • table statistics

check_circle_outline

Starburst Hive connector

../_images/hive.png

check_circle_outline

  • parallelism

  • table statistics

  • user impersonation

  • Kerberos authentication

check_circle_outline

Starburst Iceberg connector

../_images/iceberg.png

check_circle_outline

  • parallelism

  • table statistics

check_circle_outline

Hudi connector

../_images/hudi.png

check_circle_outline

check_circle_outline

  • identical

RDBMS connectors#

RDBMS connectors support proprietary and open source relational database management systems (RBDMS), as well as services that offer such databases as a service. These systems expose data in the typical tabular format supported by SQL.

Use the label list and and other information to read the table content.

Features of connectors for RDBMS#

Connector description

Trino

SEP

Starburst BigQuery connector

../_images/bigquery.png

check_circle_outline

  • parallelism

check_circle_outline

  • OAuth 2.0 token pass-through

  • managed statistics

ClickHouse connector

../_images/clickhouse.png

check_circle_outline

check_circle_outline

  • identical

Starburst IBM Db2 connector

../_images/db2.png

not_interested

check_circle_outline

  • license required

  • table statistics

  • managed statistics

  • pushdown

  • user impersonation

  • password credential pass-through

Starburst Greenplum connector

../_images/greenplum.png

not_interested

check_circle_outline

  • license required

  • table statistics

  • pushdown

  • user impersonation

  • Kerberos authentication

  • Kerberos credential pass-through

  • password credential pass-through

Kudu connector

../_images/kudu.png

check_circle_outline

  • parallelism

check_circle_outline

  • managed statistics

MariaDB connector

../_images/mariadb.png

check_circle_outline

  • pushdown

check_circle_outline

  • identical

Starburst MaxCompute connector

../_images/maxcompute.png

not_interested

check_circle_outline

  • pushdown

MySQL connector

../_images/mysql.png

check_circle_outline

  • table statistics

  • pushdown

check_circle_outline

  • licensed add-ons

  • pushdown (enhanced)

  • AWS IAM authentication

  • managed statistics

Starburst Netezza connector

../_images/netezza.png

not_interested

check_circle_outline

  • license required

  • table statistics

  • managed statistics

  • pushdown

  • user impersonation

  • Kerberos authentication

  • Kerberos credential pass-through

  • password credential pass-through

Oracle connector

../_images/oracle.png

check_circle_outline

  • pushdown

check_circle_outline

  • licensed add-ons

  • parallelism

  • table statistics

  • pushdown (enhanced)

  • managed statistics

  • user impersonation

  • Kerberos authentication

  • Kerberos credential pass-through

  • password credential pass-through

PostgreSQL connector

../_images/postgresql.png

check_circle_outline

  • table statistics

  • pushdown

check_circle_outline

  • licensed add-ons

  • pushdown (enhanced)

  • managed statistics

  • user impersonation

  • Kerberos authentication

  • Kerberos credential pass-through

  • password credential pass-through

  • AWS IAM authentication

Starburst Redshift connector

../_images/redshift.png

check_circle_outline

  • pushdown

check_circle_outline

  • licensed add-ons

  • table statistics

  • managed statistics

  • pushdown (enhanced)

  • user impersonation

  • password credential pass-through

  • AWS IAM authentication

Starburst SAP HANA connector

../_images/sap-hana.png

not_interested

check_circle_outline

  • license required

  • table statistics

  • pushdown

SingleStore connector

../_images/singlestore.png

check_circle_outline

  • pushdown

  • Kerberos authentication

check_circle_outline

  • licensed add-ons

  • table statistics

  • managed statistics

  • pushdown (enhanced)

  • parallelism

Starburst SQL Server connector

../_images/sqlserver.png

check_circle_outline

  • table statistics

  • pushdown

check_circle_outline

  • licensed add-ons

  • pushdown (enhanced)

  • managed statistics

  • user impersonation

  • password credential pass-through

  • Kerberos authentication

  • Kerberos credential pass-through

  • NTLM authentication

Starburst Snowflake connector

check_circle_outline

check_circle_outline

  • license required

  • parallelism

  • table statistics

  • managed statistics

  • pushdown

  • user impersonation

  • password credential pass-through

  • OAuth 2.0 token pass-through

  • JWT pass-through

Starburst Synapse connector

../_images/synapse.png

not_interested

check_circle_outline

  • license required

  • table statistics

  • managed statistics

  • pushdown

  • user impersonation

  • password credential pass-through

  • Active Directory password authentication

  • Active Directory password credential pass-through

Starburst Teradata connectors

../_images/teradata.png

not_interested

check_circle_outline

  • license required

  • parallelism

  • table statistics

  • managed statistics

  • pushdown

  • user impersonation

  • Kerberos authentication

  • Kerberos credential pass-through

  • password credential pass-through

Starburst Vertica connector

../_images/vertica.png

not_interested

check_circle_outline

  • license required

  • table statistics

  • pushdown

  • user impersonation

  • password credential pass-through

Starburst Generic JDBC connector

not_interested

check_circle_outline

  • license required

  • pushdown

  • user impersonation

Key-value store connectors#

Key-value store connectors support systems that store data in key-value pairs, and provide access via SQL or custom APIs.

Use the label list and and other information to read the table content.

Features of connectors for key-value stores#

Connector description

Trino

SEP

Accumulo connector

../_images/accumulo.png

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Cassandra connector

../_images/cassandra.png

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Starburst DynamoDB connector

../_images/dynamodb.png

not_interested

check_circle_outline

Ignite connector

../_images/ignite.png

check_circle_outline

  • pushdown

check_circle_outline

  • identical

Phoenix connector

../_images/phoenix.png

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Redis connector

../_images/redis.png

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Stream-processing system connectors#

Stream-processing system connector provide access to the data that flows through these systems.

Use the label list and and other information to read the table content.

Features of connectors for stream-processing systems#

Connector description

Trino

SEP

Starburst Kafka connector

../_images/kafka.png

check_circle_outline

  • parallelism

check_circle_outline

  • licensed add-ons

  • password credential pass-through

  • Kerberos authentication

  • TLS/SSL encryption (1-way SSL)

  • TLS/SSL authentication (2-way SSL)

  • Basic authentication

  • OAuth 2.0 authentication

  • OAuth 2.0 token pass-through

  • SCRAM authentication

  • Protobuf messages support

Kinesis connector

../_images/kinesis.png

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Document-oriented database connectors#

Document-oriented database connectors support systems that store data in more or less structure documents in various formats including JSON.

Use the label list and and other information to read the table content.

Features of connectors for document-oriented database systems#

Connector description

Trino

SEP

Starburst Cosmos DB connector

../_images/cosmosdb.png

not_interested

check_circle_outline

Starburst Elasticsearch connector

../_images/elasticsearch.png

check_circle_outline

  • parallelism

  • AWS IAM authentication

check_circle_outline

  • Kerberos authentication

Google Sheets connector

../_images/google-sheets.png

check_circle_outline

check_circle_outline

  • identical

Starburst MongoDB connector

../_images/mongodb.png

check_circle_outline

check_circle_outline

  • Kerberos authentication

  • Kerberos credential pass-through

  • password credential pass-through

  • pushdown

OpenSearch connector

../_images/opensearch.png

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Other connectors#

A number of connectors are support systems that cannot be added to the earlier sections are are listed in the following table.

Use the label list and and other information to read the table content.

Features of other connectors#

Connector description

Trino

SEP

Starburst Stargate

not_interested

check_circle_outline

  • license required

  • table statistics

  • managed statistics

  • pushdown

  • password credential pass-through

  • OAuth 2.0 token pass-through

Atop connector

check_circle_outline

check_circle_outline

  • identical

Druid connector

../_images/druid.png

check_circle_outline

check_circle_outline

  • identical

JMX connector

check_circle_outline

check_circle_outline

  • identical

Local file connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Memory connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Pinot connector

../_images/pinot.png

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Prometheus connector

../_images/prometheus.png

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Starburst Salesforce connector

../_images/salesforce.png

not_interested

check_circle_outline

  • license required

  • pushdown

Starburst Splunk connector

../_images/splunk.png

not_interested

check_circle_outline

  • license required

  • pushdown

TPCH connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical

TPCDS connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical