It is required to generate OAuth 2.0 tokens using Google OAuth 2.0 Playground before configuring a shared connection resource to BigQuery from TIBCO ActiveMatrix BusinessWorks Plug-in for Google BigQuery 6.1.0 Hotfix 1. Please refer to the following steps on how to generate the tokens:
Before beginning:
The user must be assigned to the Owner role for the project on Google Cloud Platform.
Client Configuration:
- Log onto the Google Cloud Platform console, select your project and click APIs&Services > Credentials.
- Create a new credential selecting "OAuth Client Id" option. The application type must be set to "Web application".
- Enter the URL to Google OAuth Playground (https://developers.google.com/oauthplayground) as one of the authorized redirect URIs.
- Additionally, add more than one redirect URI. If no URLs are configured for the application, use http://localhost as alternate redirect URI.
- Click "Create" and download the JSON file for the client. Note and confirm the Client ID, Client secret, Project ID, and Redirect URIs are defined accurately in the file.
Generate the token on Google OAuth Playground:
- Navigate to the OAuth2.0 Playground URL: https://developers.google.com/oauthplayground.
- Click "OAuth 2.0 configuration" button on the right top of the window.
- On the "OAuth 2.0 configuration" page, select "Use your own OAuth credentials" check box.
- Copy the Client ID and the Client secret from the previously downloaded JSON file, and then click "Close" to close the page.
- In the left panel of the window, please select the following in Step 1 Select & authorize APIs:
- BigQuery API v2
- https://www.googleapis.com/auth/bigquery
- https://www.googleapis.com/auth/cloud-platform
- Drive API v3
- https://www.googleapis.com/auth/drive
- Click Authorize APIs
- Now, the "Exchange authorization code for tokens" section will be pre-filled with an authorization code. Click "Exchange Authorization code for tokens" to generate the "Access token" and the "Refresh Token".
- Please save the the "Access token" and the "Refresh Token" for further use.
Note: After generating the tokens, please delete the playground URL from the Authorized Redirect URIs section. Please save the JSON file for further use.