🔍BigQuery

If your organization uses Google Cloud Private Service Connect, Arcwise can’t support it yet. Please let us know if this is something you need!

Step 1: Create a Service Account in GCP

1. Choose an existing service account or create a new one. Instructions on setting up a GCP service account can be found here. We recommend a new service account: Arcwise

2. Grant the service account the proper level of access to BigQuery. More information on permissions here. Access should be granted from IAM management. Minimally, Arcwise requires:

   1. BigQuery Job User

   2. BigQuery Read Session User

   3. BigQuery Data Viewer (* This can be granted on a per-dataset level to only the datasets you would like Arcwise to access)

3. Create a dataset in BigQuery called arcwise_snapshots. For more information on creating datasets see here.

   • Arcwise will use this dataset to create zero-cost table snapshots of tables that have been connected to Google Sheets.

4. Grant the service account the proper level of access to the arcwise_snapshots dataset. For information on how to grant access to an individual dataset see here. Grant the following access:

   1. BigQuery Data Owner

5. Generate a JSON Key file for the service account. This will be used later.

Step 2: Link Account to Arcwise

Navigate to https://admin.arcwise.app/ and go to the connections tab.

Open your JSON key file and copy+paste the contents into the textbox, then press Save.