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.