Configuring Google BigQuery workspace data connections
During workspace creation, under Connection Type, click BigQuery.
In the Source Server section, you provide the connection information for the source database:
- 1.In the Project ID field, provide the identifier of the project that contains the source database.
- 2.In the Dataset Name field, provide the name of the dataset that contains the source database.
- 3.For Service Account File, select the service account file (JSON file) for the source database.
- 4.To test the connection to the source database, click Test Source Connection.
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.
In the Destination Server section, you provide the connection information for the destination database:
- 1.In the Project ID field, provide the identifier of the project that contains the destination database.
- 2.In the Dataset Name field, provide the name of the dataset that contains the destination database.
- 3.For Service Account File, select the service account file (JSON file) for the destination database.
- 4.To test the connection to the destination database, click Test Destination Connection.