> ## Documentation Index
> Fetch the complete documentation index at: https://docs.paradime.io/llms.txt
> Use this file to discover all available pages before exploring further.

# GCP BigQuery Transfer

> Trigger Google BigQuery Data Transfer scheduled queries from Paradime Bolt and the CLI to orchestrate BigQuery data movement next to your dbt jobs.

[Google BigQuery Data Transfer Service](https://cloud.google.com/bigquery/docs/dts-introduction) automates data movement into BigQuery, including scheduled queries. Trigger BigQuery scheduled queries as part of your Paradime Bolt schedules using the Paradime CLI.

## What you can do

* Trigger one or more BigQuery scheduled queries by display name, optionally waiting for the run to complete
* List all BigQuery scheduled queries

## Prerequisites

* `GCP_SERVICE_ACCOUNT_KEY_FILE`: path to a GCP service account JSON key file with permissions to trigger and list scheduled queries
* `GCP_PROJECT_ID`: your GCP project ID
* `GCP_LOCATION`: BigQuery Data Transfer location (e.g. 'us', 'eu', 'us-central1'), defaults to 'us'

## Trigger from Bolt

Set your credentials as [environment variables](/products/settings/environment-variables/bolt-schedule-env-variables) on your Bolt schedule, then run the command as part of the schedule.

See the full command reference, flags, and examples in the [GCP BigQuery Transfer CLI](/developers/paradime-cli/gcp-bigquery-transfer-cli) documentation.


## Related topics

- [GCP BigQuery Data Transfer CLI](/developers/paradime-cli/gcp-bigquery-transfer-cli.md)
- [BigQuery OAuth](/products/settings/connections/connection-security/bigquery-oauth.md)
- [BigQuery](/products/settings/connections/development-environment/bigquery.md)