Google BigQuery

Overview

Tonic supports moving data from one dataset to another within the same BigQuery project and also between different BigQuery projects.
Tonic uses service accounts to access both the source and destination datasets.
Configuring access to BiqQuery in Tonic requires the following information for the source and destination databases:
  • Project ID
  • Dataset Name
  • Service Account Key File (JSON)
Even if the source and destination are in the same BigQuery project, Tonic recommends that you create separate service accounts for the source and destination.

Source

When you create the service account for the source dataset, you should use the "Viewer" role to grant the service account access to the project.
Tonic does not require write permissions to the source dataset.

Destination

When you create the service account for the destination dataset, you should use the "Editor" role to grant the service account access to the project.
Copy link
On this page
Overview
Source
Destination