See Stacksync in action with a solution architect. Book a demo ↗
StacksyncDocs
StacksyncCommunityBook a demoContact Support
HomeTwo-way syncAgentic WorkflowsGeniesEnterprise OSMCPEDIConnectorsSecurity and Other ResourcesChangelogDevelopers
BigQuery

Authorize BigQuery

Authorize your BigQuery app and sync data with Stacksync

Enabling Required Google APIs

The following APIs are required by the Stacksync services in order to access the data and create a sync in BigQuery:

  1. Cloud Run API (to create a secure portal for real-time notification service in your space)
  2. Cloud Resource Manager API (to set up all services)
  3. BigQuery API (this is where your data resides)
  4. Eventarc API (a notification service that enables real-time updates to happen)

1. Open https://console.cloud.google.com/apis/library

2. Search for the API "cloud run API"

Google Cloud API Library with "cloud run api" typed in the search box

3. Click on the API "Cloud Run API"

Google Cloud API Library search results with "Cloud Run API" highlighted

4. Enable the API

Google Cloud Run API product page with the "Enable" button highlighted

5. Repeat Steps 2-3 for the following APIs

Cloud Resource Manager API

Google Cloud API Library search results with "Cloud Resource Manager API" highlighted

BigQuery API

Google Cloud API Library search results with "BigQuery API" highlighted

Eventarc API

Google Cloud API Library search results with "Eventarc API" highlighted

Create Service Account

The Service Account gives access to Stacksync to your data for it to be synced. It is used to set up all the necessary Stacksync Services in your Google Cloud Project. You will need to create one Service Account dedicated to Stacksync which will enable you with better access control.

1. Open https://console.cloud.google.com/iam-admin/serviceaccounts

2. Click "Create Service Account"

Google Cloud IAM & Admin Service accounts page with "Create service account" highlighted

3. Fill in the Service Account details

Google Cloud service account details form with name "demo-account" and the "Create and continue" button

4. Click "Select a role"

Google Cloud "Grant this service account access to project" step with the "Select a role" dropdown highlighted

5. Add the following Roles to the Service Account

These roles are necessary for Stacksync to get data access and set up the required services to make the data sync happen.

  1. BigQuery Data Editor
  2. BigQuery Job User
  3. Cloud Functions Service Agent
  4. Cloud Run Developer
  5. Eventarc Event Receiver
  6. Eventarc Service Agent
Service account roles: BigQuery Data Editor, BigQuery Job User, Cloud Functions Service Agent, Cloud Run Developer, Eventarc Event Receiver

6. Click "Continue"

Google Cloud service account with the five BigQuery sync roles added and the "Continue" button highlighted

7. Click "DONE"

Google Cloud create service account final step, skipping user access and clicking "Done"

Adding Credentials to Stacksync

1. Go to https://console.cloud.google.com/iam-admin/serviceaccounts

2. Click "Keys"

Google Cloud demo-account service account details with the "Keys" tab highlighted

3. Click "Add Key" and Select "Create New Key"

Google Cloud IAM service account Keys tab with the "Add Key" menu open and "Create new key" highlighted.

4. Select Key Type "JSON" and click "Create"

After clicking "Create", the JSON file will be downloaded.

Google Cloud "Create private key" dialog with Key type "JSON" selected and the "Create" button highlighted.

5. Select BigQuery in the Create Base page in Stacksync

Stacksync Create New Base page at the Connect Apps step, with the BigQuery app tile highlighted.

6. Upload the JSON file from Step 4 and Click "Authorize App"

Stacksync BigQuery dialog with the "Service Account Key" file upload field and the "Authorize App" button highlighted.

BigQuery

Connect your CRM to your Data Warehouse with Stacksync!

HubSpot

Two-way sync between HubSpot and your other systems.

On this page

Enabling Required Google APIs 1. Open https://console.cloud.google.com/apis/library2. Search for the API "cloud run API"3. Click on the API "Cloud Run API"4. Enable the API5. Repeat Steps 2-3 for the following APIsCreate Service Account1. Open https://console.cloud.google.com/iam-admin/serviceaccounts2. Click "Create Service Account"3. Fill in the Service Account details4. Click "Select a role"5. Add the following Roles to the Service Account6. Click "Continue"7. Click "DONE"Adding Credentials to Stacksync1. Go to https://console.cloud.google.com/iam-admin/serviceaccounts2. Click "Keys"3. Click "Add Key" and Select "Create New Key"4. Select Key Type "JSON" and click "Create"5. Select BigQuery in the Create Base page in Stacksync6. Upload the JSON file from Step 4 and Click "Authorize App"