Google BigQuery

BigQuery connector using google-cloud-bigquery and sqlglot.

Property	Value
Key	bigquery
Source type	warehouse
Implementation	planned
Active by default	no
Default cache strategy	semantic_first; semantic serving is disabled, so only exact repeats are served
Capabilities	supports_cost_metadata, supports_discovery, supports_field_permissions, supports_ingestion, supports_query

Implementation is how complete the adapter is. It is not a release status: what the project supports and has certified is on Feature status and in the connector support matrix, and nothing is past public beta yet.

Connection configuration

Secret fields should be given as a reference, <field>_ref, such as env://NAME, rather than a literal.

Key	Secret
project	no
service_account_json_ref	no
location	no
service_account_json	yes; prefer service_account_json_ref

Default role templates

Offered when a source is created with default roles. Edit them to fit.

analyst

Effect	Action	Resource type	Pattern
allow	db.schema.list	db.schema	*
allow	db.table.describe	db.table	*.*
allow	db.table.select	db.table	*.*
allow	discovery.search	discovery.asset	*
allow	discovery.asset.read	discovery.asset	*

blocked

Effect	Action	Resource type	Pattern
deny	*	*	*