Add the Google BigQuery Connector
Authenticate to Google BigQuery
After you add the connector, you need to set the required properties. CData Sync supports authenticating to Google BigQuery in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.OAuth
OAuth JWT
To connect with a Google service account, specify the following properties:- Auth Scheme: Select OAuthJWT.
- OAuth JWT Cert: Enter your Java web tokens (JWT) certificate store.
- OAuth JWT Cert Type: Enter the type of key store that contains your JWT Certificate. The default type is GOOGLEJSONBLOB.
- (Optional) OAuth JWT Subject: Enter the user subject for which the application is requesting delegated access.
GCP Instance Account
AWS Workload Identity
To connect with AWS Workload Identity federation credentials, specify the following properties:
- Auth Scheme: Select AWSWorkloadIdentity.
- AWS Workload Identity Config: Enter a semicolon-separated list of
Key=Valueproperties, as shown in this example:AWSWorkloadIdentityConfig="AuthScheme=AwsRootKeys;AccessKey='AKIAABCDEF123456';SecretKey=...;Region=us-east-1"Note that it is optional as to whether you want to include the value within quotes.
- Workload Pool Id: Enter The identifier (Id) of your Workload Identity Federation pool.
- Workload Project Id: Enter the Id of the Google Cloud project that hosts your Workload Identity Federation pool.
- Workload Provider Id: Enter the Id of your Workload Identity Federation pool provider.
Azure Workload Identity
To connect with single sign-on via PingFederate, specify the following properties:
- Auth Scheme: Select AzureWorkloadIdentity.
- Azure Workload Identity Config: Enter a semicolon-separated list of
Key=Valueproperties, as shown in this example:AzureWorkloadIdentityConfig="AuthScheme=AzureServicePrincipal;AzureTenant=directory (tenant) id;OAuthClientID=application (client) id;OAuthClientSecret=client secret;AzureResource=application id uri;"Note that it is optional as to whether you want to include the value within quotes.
- Workload Pool Id: Enter The identifier (Id) of your Workload Identity Federation pool.
- Workload Project Id: Enter the Id of the Google Cloud project that hosts your Workload Identity Federation pool.
Complete Your Connection
To complete your connection:- Specify the following settings:
- Project Id: Enter the identifier of the project to which Sync should connect.
- (Optional) Dataset Id: Enter the identifier of the data set to which Sync should connect.
- Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)
- Connect to Google BigQuery to connect to your Google BigQuery account.
- Click Create & Test to create your connection.