Starburst connectors overview#

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:

Identical connectors are the same as the connectors available from the open source Trino project

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. Any included feature that is proprietary, but does not require a license includes a (free) after the label.

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

pushdown

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

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

AWS IAM authentication

Connector supports Amazon IAM authentication and policy management

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

BigQuery connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Starburst BigQuery connector

check_circle_outline

check_circle_outline

Starburst Delta Lake connector

not_interested

check_circle_outline

Starburst Hive connector

check_circle_outline

  • parallelism

  • table statistics

  • user impersonation

  • Kerberos authentication

check_circle_outline

Iceberg connector

check_circle_outline

check_circle_outline

  • identical

Starburst Iceberg connector

check_circle_outline

check_circle_outline

MapR Hive support

not_interested

check_circle_outline

  • license required

  • parallelism

  • table statistics

  • user impersonation

  • MAPR SASL

IBM Cloud Object Storage support for the Hive connector

not_interested

check_circle_outline

  • license required

  • parallelism

  • table statistics

Kudu connector

check_circle_outline

  • parallelism

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

ClickHouse connector

check_circle_outline

check_circle_outline

  • identical

Starburst IBM DB2 connector

not_interested

check_circle_outline

  • license required

  • table statistics

  • pushdown

  • user impersonation

  • password credential pass-through

Starburst Greenplum connector

not_interested

check_circle_outline

  • license required

  • table statistics

  • pushdown

  • user impersonation

  • Kerberos authentication

  • Kerberos credential pass-through

  • password credential pass-through

Starburst MySQL connector

check_circle_outline

  • pushdown

check_circle_outline

  • licensed add-ons

  • table statistics (free)

  • pushdown (enhanced)

  • AWS IAM authentication

Starburst Netezza connector

not_interested

check_circle_outline

  • license required

  • table statistics

  • pushdown

  • user impersonation

  • Kerberos authentication

  • Kerberos credential pass-through

  • password credential pass-through

Starburst Oracle connector

check_circle_outline

  • pushdown

check_circle_outline

  • licensed add-ons

  • parallelism

  • table statistics (free)

  • pushdown (enhanced)

  • user impersonation

  • Kerberos authentication

  • Kerberos credential pass-through

  • password credential pass-through

Starburst PostgreSQL connector

check_circle_outline

  • pushdown

check_circle_outline

  • licensed add-ons

  • table statistics (free)

  • pushdown (enhanced)

  • user impersonation

  • Kerberos authentication

  • Kerberos credential pass-through

  • password credential pass-through

  • AWS IAM authentication

Starburst Redshift connector

check_circle_outline

  • pushdown

check_circle_outline

  • licensed add-ons

  • table statistics (free)

  • pushdown (enhanced)

  • user impersonation

  • password credential pass-through

  • AWS IAM authentication

Starburst SAP HANA connector

not_interested

check_circle_outline

  • license required

  • table statistics

  • pushdown

Starburst SingleStore (MemSQL) connector

check_circle_outline

  • pushdown

check_circle_outline

  • licensed add-ons

  • table statistics (free)

  • pushdown (enhanced)

Starburst SQL Server connector

check_circle_outline

  • pushdown

check_circle_outline

  • licensed add-ons

  • table statistics (free)

  • pushdown (enhanced)

  • user impersonation

  • password credential pass-through

  • Kerberos authentication

  • Kerberos credential pass-through

Starburst Snowflake connector

not_interested

check_circle_outline

  • license required

  • parallelism

  • table statistics

  • pushdown

  • user impersonation

  • password credential pass-through

  • OAuth 2.0 token pass-through

Starburst Synapse connector

not_interested

check_circle_outline

  • license required

  • table statistics

  • pushdown

  • user impersonation

  • password credential pass-through

  • Active Directory password authentication

  • Active Directory password credential pass-through

Starburst Teradata connectors

not_interested

check_circle_outline

  • license required

  • parallelism

  • table statistics

  • pushdown

  • user impersonation

  • Kerberos authentication

  • Kerberos credential pass-through

  • password credential pass-through

Starburst Vertica connector

not_interested

check_circle_outline

  • license required

  • parallelism

  • 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

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Cassandra connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Starburst DynamoDB connector

not_interested

check_circle_outline

Phoenix connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Redis connector

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

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

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 the 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

Elasticsearch connector

check_circle_outline

  • parallelism

  • AWS IAM authentication

check_circle_outline

  • identical

Google Sheets connector

check_circle_outline

check_circle_outline

  • identical

MongoDB connector

check_circle_outline

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

  • pushdown

Druid connector

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

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Prometheus connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Starburst Salesforce connector

not_interested

check_circle_outline

  • license required

  • pushdown

Starburst Splunk connector

not_interested

check_circle_outline

  • license required

TPCH connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical

TPCDS connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical