Starburst BigQuery connector#

The Starburst BigQuery connector is an extended, tested and fully supported version of the BigQuery connector with identical configuration and usage.

Requirements#

Fulfill the BigQuery connector requirements.
Additional features of the connector require a valid Starburst Enterprise license, unless otherwise noted.

Configuration#

The connector configuration is similar to the configuration for the base BigQuery connector, with the following additional properties:

BigQuery configuration properties#
Property name	Description
`bigquery.project-prefix-for-schema.enabled`	Allow accessing other projects in BigQuery by including the project id with the schema name in queries: SELECT * FROM catalog."project-id.dataset".table Defaults to `false`.
`bigquery.project-cache-ttl`	Frequency of checks for project names as duration. Defaults to `30m`

SQL support#

The connector supports all of the SQL statements listed in the BigQuery connector documentation.

Table statistics#

BigQuery does not expose table statistics, and the connector can therefore not use cost based optimizations to improve query processing performance based on the actual data in the data source.

Security#

The Starburst BigQuery connector includes an additional security-related feature, detailed in the following section.

OAuth 2.0 token pass-through#

The BigQuery connector supports OAuth 2.0 token pass-through when SEP is configured to use Google Cloud Platform as an OAuth 2.0 identity provider.

Enable OAUTH2_PASSTHROUGH in the catalog properties file using the BigQuery connector:

bigquery.authentication.type=OAUTH2_PASSTHROUGH