> ## 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 BigQuery Data Transfer scheduled queries on demand from Paradime Bolt schedules to refresh datasets as part of your dbt™ pipelines.

[GCP BigQuery Transfer](https://cloud.google.com/bigquery/docs/dts-introduction) Data Transfer Service automates data movement into BigQuery on a schedule, including scheduled queries. Trigger it from a Paradime Bolt schedule with the Paradime CLI, so it runs as part of your pipeline.

## What you can do

* Trigger one or more scheduled queries by display name

## Prerequisites

* A service account with permission to run BigQuery Data Transfer configs (BigQuery Admin or equivalent).

## Set up

Paradime authenticates to GCP with a service account key. Set them as [Bolt schedule environment variables](/products/settings/environment-variables/bolt-schedule-env-variables):

| Variable                       | Required | Description                                                               |
| ------------------------------ | -------- | ------------------------------------------------------------------------- |
| `GCP_SERVICE_ACCOUNT_KEY_FILE` | Required | Path to your GCP service account JSON key file.                           |
| `GCP_PROJECT_ID`               | Required | Your GCP project ID.                                                      |
| `GCP_LOCATION`                 | Optional | BigQuery Data Transfer location (for example, `us`, `eu`). Default: `us`. |

## Trigger from Bolt

Add the [Run BigQuery Scheduled Query](/products/bolt/creating-schedules/command-settings/bigquery-scheduled-query) command to a schedule. For the full command reference, flags, and examples, see the [GCP BigQuery Transfer CLI](/developers/paradime-cli/gcp-bigquery-transfer-cli).


## Related topics

- [Run BigQuery Scheduled Query](/products/bolt/creating-schedules/command-settings/bigquery-scheduled-query.md)
- [GCP BigQuery Data Transfer CLI](/developers/paradime-cli/gcp-bigquery-transfer-cli.md)
- [BigQuery OAuth](/integrations/bigquery/oauth.md)
- [BigQuery](/integrations/bigquery/index.md)
- [BigQuery Tools](/products/dino-ai/tools-and-features/warehouse-tool/bigquery-tools.md)