Tonic
Search…
Google BigQuery

Overview

Tonic supports moving data from one dataset to another within the same BigQuery project and also between different BigQuery projects. Service accounts are used to access both the source and output datasets. Configuring access to BiqQuery in Tonic require the following information for both the source and destination:
    Project ID
    Dataset Name
    Service Account Key File (JSON)
Tonic recommends creating separate service accounts for the source and destination even if in the same BigQuery project.

Source

When creating the service account for the source dataset, the service account should be granted access to the project using the "Viewer" role. Tonic does not require write permissions to the source dataset.

Output

When creating the service account for the output dataset, the service account should be granted access to the project using the "Editor" role.
Last modified 3mo ago
Copy link