Google BigQuery: How do I set up my OAuth data connection?
In order to use OAuth for your Google BigQuery data connection, please follow the steps below.
Log in to your Google Cloud Platform (GCP) account and enable the following APIs (https://console.cloud.google.com/apis/dashboard):
BigQuery API
BigQuery Storage API
Set up OAuth 2.0 Client IDs for the project in which the database is hosted.
Create Credentials.
Select OAuth Client ID.
Select Application Type to be "Web Application".
Define a name for the Web Application and add the following authorized redirect URI:
Save the Client ID.
When reopening the OAuth 2.0 Client ID, you can see on the top right the clientID and clientSecret needed for the data connection setup in the EMS.
Requirements in the EMS:
Modify your network settings as described here: How do I set up a database connection?
Warning
For Uplinked database connection only.
Download the latest JDBC package which is available here: Downloads and Version History.
Additionally, download the Google BigQuery Jar which is available here: google-bigquery.jar.
Start the uplink using the following command:
Creation of user, role, permissions
java -Dloader.path=google-bigquery.jar -jar connector-jdbc.jar serve
Once the uplink is green, create a BigQuery data connection selecting Uplink and OAuth as authentication method.
Add the connection details:
Insert the following details:
Port: 443
Database Name: Name of the project in GCP
clientID: The clientID from the OAuth 2.0 Client ID created in GCP
clientSecret: The clientSecret from the OAuth 2.0 Client ID created in GCP
Click Save which automatically triggers the OAuth flow.
Log in to Google with the same user that is used in your GCP project.
Upon the warning click Advanced and continue (Go to celonis.cloud).
Accept the access of celonis.cloud to the Google Account (tick the checkbox) and click Continue.