Docs · Connector reference

Google BigQuery connector reference

Operations, inputs, troubleshooting, and questions for the Google BigQuery connection.

Set up and verify the Google BigQuery connection

Choose one task and its account, and match the reads and actions on the overview page to it before granting provider permissions.
Prepare the connection settings from the overview page, connect the provider in Deixic, and choose which tools your agent can use.
Try a small task with a known result, and compare the returned identity and resource with what the account owner expects.
Review the retrieved information, retain its identifiers, and keep any later change in a separate, explicitly authorized step.

Information your agent can use

Resource	Record identity	Start with	Page coverage
Projects	`id`	Top level	Cursor

Record identity: Match on these fields before joining or deduplicating results; where none is specified, check the returned record first.
Start with: Resolve the parent identifier first.
Cursor: Cursor pagination. Continue from the returned cursor; an initial page is not a complete inventory.

Supported operations

Review the inputs before granting an action to an agent. Required inputs must be supplied, optional inputs narrow the request, and provider permissions apply in addition to Deixic policy.

Read: Retrieves information; check the returned scope and identifiers before use.

Operation	Effect	Approval	Provider permissions	Inputs
Bigquery Query	Read	Approval required	https://www.googleapis.com/auth/bigquery	4
Bigquery Projects List	Read	By policy	https://www.googleapis.com/auth/bigquery	2
Bigquery Datasets List	Read	By policy	https://www.googleapis.com/auth/bigquery	4
Bigquery Tables List	Read	By policy	https://www.googleapis.com/auth/bigquery	4
Bigquery Tables Get	Read	By policy	https://www.googleapis.com/auth/bigquery	3
Bigquery Jobs Query	Read	By policy	https://www.googleapis.com/auth/bigquery	8
Bigquery Jobs Get Query Results	Read	By policy	https://www.googleapis.com/auth/bigquery	7

Inputs by operation

Bigquery Query Read · approval required

Inputs for Bigquery Query
Input	Requirement	Accepted value
`location`	Optional	stringMaximum characters: 64
`max_results`	Optional	integerMinimum: 1Maximum: 1000
`project_id`	Required	string
`query`	Required	stringMinimum characters: 1Maximum characters: 10000

Bigquery Projects List Read

Inputs for Bigquery Projects List
Input	Requirement	Accepted value
`max_results`	Optional	integerMinimum: 1Maximum: 200
`page_token`	Optional	stringMinimum characters: 1Maximum characters: 4096

Bigquery Datasets List Read

Inputs for Bigquery Datasets List
Input	Requirement	Accepted value
`all`	Optional	boolean
`max_results`	Optional	integerMinimum: 1Maximum: 200
`page_token`	Optional	stringMinimum characters: 1Maximum characters: 4096
`project_id`	Required	stringMinimum characters: 1Maximum characters: 128

Bigquery Tables List Read

Inputs for Bigquery Tables List
Input	Requirement	Accepted value
`dataset_id`	Required	stringMinimum characters: 1Maximum characters: 1024
`max_results`	Optional	integerMinimum: 1Maximum: 200
`page_token`	Optional	stringMinimum characters: 1Maximum characters: 4096
`project_id`	Required	stringMinimum characters: 1Maximum characters: 128

Bigquery Tables Get Read

Inputs for Bigquery Tables Get
Input	Requirement	Accepted value
`dataset_id`	Required	stringMinimum characters: 1Maximum characters: 1024
`project_id`	Required	stringMinimum characters: 1Maximum characters: 128
`table_id`	Required	stringMinimum characters: 1Maximum characters: 1024

Bigquery Jobs Query Read

Inputs for Bigquery Jobs Query
Input	Requirement	Accepted value
`default_dataset`	Optional	object
`dry_run`	Optional	boolean
`location`	Optional	stringMinimum characters: 1Maximum characters: 64
`max_results`	Optional	integerMinimum: 1Maximum: 1000
`maximum_bytes_billed`	Optional	integerMinimum: 1Maximum: 10737418240
`project_id`	Required	stringMinimum characters: 1Maximum characters: 128
`query`	Required	stringMinimum characters: 1Maximum characters: 10000
`timeout_ms`	Optional	integerMinimum: 1Maximum: 60000

Bigquery Jobs Get Query Results Read

Inputs for Bigquery Jobs Get Query Results
Input	Requirement	Accepted value
`job_id`	Required	stringMinimum characters: 1Maximum characters: 1024
`location`	Optional	stringMinimum characters: 1Maximum characters: 64
`max_results`	Optional	integerMinimum: 1Maximum: 1000
`page_token`	Optional	stringMinimum characters: 1Maximum characters: 4096
`project_id`	Required	stringMinimum characters: 1Maximum characters: 128
`start_index`	Optional	integerMinimum: 0Maximum: 1000000000
`timeout_ms`	Optional	integerMinimum: 1Maximum: 60000

When the Google BigQuery task does not produce the expected result

Connected, but the expected data is missing

Check the identity behind the oauth connection and its access to the specific resource; a successful connection does not establish access to every object.

Compare the lookup against one known record first, and keep an empty response separate from a permissions error.

The answer covers only part of the data

Check the resource’s page coverage, query filters, and result limit, and have the agent state the account and time window it inspected, so a partial response yields a scoped answer.

The agent keeps doing the same work

Inspect the action history for repeated targets and inputs, keep the successful result’s identifiers with the task, and refresh a lookup only when the information changed.

The next step needs a write

Use a separate authorized action or a person to make the change; broader credentials do not add a write operation to this connection.

See how an action proceeds and how to review an approval.

Questions about the Google BigQuery connector

Can I use my existing agent with Google BigQuery?

Yes: connect your agent to Deixic through MCP, choose which connected tools it can use, and Deixic checks calls routed through its gateway; Dex is available if your team also wants an agent.

Can an agent change data in Google BigQuery?

This connector supports reads. Use a configured connection to retrieve information and prepare a recommendation; it provides no action for changing provider data, even if the provider’s API offers writes.

What do I need to connect Google BigQuery?

Prepare Client ID, Client secret, Access token, Refresh token; the connection uses OAuth, and the connected identity’s provider permissions determine which resources it can access.

Does connecting Google BigQuery keep every answer up to date?

No: an earlier answer is still an earlier answer, so for a decision that depends on current state, have the agent refresh the source and retain the lookup time, and save stable instructions separately from facts that can change.

Google BigQuery connector overview Docs All connectors