GCP BigQuery Transfer

Google BigQuery Data Transfer Service 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 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 documentation.