Google BigQuery

BigQuery connector using google-cloud-bigquery and sqlglot.

Property	Value
Key	bigquery
Source type	warehouse
Status	planned
Active by default	no
Default cache strategy	semantic_first
Capabilities	supports_cost_metadata, supports_discovery, supports_field_permissions, supports_ingestion, supports_query

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