Search…
⌃K
Links

Configuring Google BigQuery workspace data connections

During workspace creation, under Connection Type, click BigQuery.

Connecting to the source database

In the Source Server section, you provide the connection information for the source database:
  1. 1.
    In the Project ID field, provide the identifier of the project that contains the source database.
  2. 2.
    In the Dataset Name field, provide the name of the dataset that contains the source database.
  3. 3.
    For Service Account File, select the service account file (JSON file) for the source database.
  4. 4.
    To test the connection to the source database, click Test Source Connection.

Blocking data generation on all schema changes

By default, data generation is not blocked as long as schema changes do not conflict with your workspace configuration.
To block data generation when there are any schema changes, regardless of whether they conflict with your workspace configuration, toggle Block data generation on schema changes to the on position.

Connecting to the destination database

In the Destination Server section, you provide the connection information for the destination database:
  1. 1.
    In the Project ID field, provide the identifier of the project that contains the destination database.
  2. 2.
    In the Dataset Name field, provide the name of the dataset that contains the destination database.
  3. 3.
    For Service Account File, select the service account file (JSON file) for the destination database.
  4. 4.
    To test the connection to the destination database, click Test Destination Connection.