SEP connectors overview#

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

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 Presto and SEP connectors.

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

Label/symbol

Description

check_circle_outline

Connector is available for Presto

not_interested

Connector is only available with SEP, not available with Presto

identical

Connector included in SEP is identical to the Presto 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 of aggregate function, LIMIT 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 passthrough

Connector supports passthrough of Kerberos authentication credentials to the underlying data source

password credential passthrough

Connector supports passthrough of password authentication credentials to the underlying data source

If a feature, such as pushdown is mentioned in the Presto and the SEP column, this means that some pushdown support is available with Presto, 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

Presto key features

Starburst Enterprise Presto key features or extensions

BigQuery connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Starburst Delta Lake connector

not_interested

check_circle_outline

  • license required

  • parallelism

  • table statistics

Starburst Hive connector

check_circle_outline

  • parallelism

  • table statistics

  • user impersonation

  • Kerberos authentication

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

Presto

Starburst Enterprise Presto

Starburst IBM DB2 connector

not_interested

check_circle_outline

  • license required

  • table statistics

  • pushdown

  • user impersonation

Starburst Greenplum connector

not_interested

check_circle_outline

  • license required

  • table statistics

  • pushdown

  • user impersonation

  • Kerberos authentication

  • Kerberos credential passthrough

  • password credential passthrough

Starburst MemSQL connector

check_circle_outline

  • pushdown

check_circle_outline

  • licensed add-ons

  • table statistics (free)

  • pushdown (enhanced)

Starburst MySQL connector

check_circle_outline

  • pushdown

check_circle_outline

  • licensed add-ons

  • table statistics (free)

  • pushdown (enhanced)

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 passthrough

  • password credential passthrough

Starburst PostgreSQL connector

check_circle_outline

  • pushdown

check_circle_outline

  • licensed add-ons

  • table statistics (free)

  • pushdown (enhanced)

  • user impersonation

  • Kerberos authentication

  • Kerberos credential passthrough

  • password credential passthrough

Redshift Connector

check_circle_outline

  • pushdown

check_circle_outline

  • identical

Starburst SAP HANA connector

not_interested

check_circle_outline

  • license required

  • pushdown

Starburst SQL Server connector

check_circle_outline

  • pushdown

check_circle_outline

  • licensed add-ons

  • table statistics (free)

  • pushdown (enhanced)

  • user impersonation

Starburst Snowflake connector

not_interested

check_circle_outline

  • license required

  • parallelism

  • table statistics

  • pushdown

  • user impersonation

Starburst Teradata connectors

not_interested

check_circle_outline

  • license required

  • parallelism

  • table statistics

  • pushdown

  • user impersonation

  • Kerberos authentication

  • Kerberos credential passthrough

  • password credential passthrough

Starburst Generic JDBC connector

not_interested

check_circle_outline

  • license required

  • pushdown

  • user impersonation

  • password credential passthrough

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

Presto

Starburst Enterprise Presto

Accumulo Connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical

Cassandra Connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical

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

Presto

Starburst Enterprise Presto

Starburst Kafka connector

check_circle_outline

  • parallelism

check_circle_outline

  • licensed add-ons

  • Kerberos authentication

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

Presto

Starburst Enterprise Presto

Elasticsearch Connector

check_circle_outline

  • parallelism

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 can not 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

Presto

Starburst Enterprise Presto

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

TPCH Connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical

TPCDS Connector

check_circle_outline

  • parallelism

check_circle_outline

  • identical