Connect Multiwoven to BigQuery

This guide will help you configure the BigQuery Connector in Multiwoven to access and use your BigQuery data.

Prerequisites

Before you begin, you’ll need to:

  1. Enable BigQuery API and Locate Dataset(s):

    • Log in to the Google Developers Console.
    • If you don’t have a project, create one.
    • Enable the BigQuery API for your project.
    • Copy your Project ID.
    • Find the Project ID and Dataset ID of your BigQuery datasets. You can find this by querying the INFORMATION_SCHEMA.SCHEMATA view or by visiting the Google Cloud web console.
  2. Create a Service Account:

  3. Grant Access:

    • In the Google Cloud web console, navigate to the IAM & Admin section and select IAM.
    • Find your service account and click on edit.
    • Go to the “Assign Roles” tab and click “Add another role”.
    • Search and select the “BigQuery User” and “BigQuery Data Viewer” roles.
    • Click “Save”.
  4. Download JSON Key File:

    • In the Google Cloud web console, navigate to the IAM & Admin section and select IAM.
    • Find your service account and click on it.
    • Go to the “Keys” tab and click “Add Key”.
    • Select “Create new key” and choose JSON format.
    • Click “Download”.

Steps

Authentication

Authentication is supported via the following:

  • Dataset ID and JSON Key File

    • Dataset ID: The ID of the dataset within Google BigQuery that you want to access. This can be found in Step 1.
    • JSON Key File: The JSON key file containing the authentication credentials for your service account.

Supported sync modes

ModeSupported (Yes/No/Coming soon)
Incremental syncYES
Full refreshComing soon