Accessing BigQuery using OAuth 2.0 authentication mode
Use OAuth 2.0 - Authorization Code grant to connect BigQuery components to Google BigQuery in a Standard Job.
This mode is available starting from 8.0.1-R2026-03.
Before you configure the component, create OAuth credentials in Google Cloud:
-
In Google Cloud Console, create an OAuth client with Desktop app as the application type.
-
Copy the generated client ID and client secret values.
Only Desktop app OAuth client credentials are supported for this authentication mode.
To configure tBigQueryInput, tBigQueryOutput, tBigQuerySQLRow, or tBigQueryBulkExec with OAuth 2.0:
-
In the component Basic settings, select OAuth 2.0 - Authorization Code grant from Authentication mode.
-
In Client ID and Client secret, enter the values created in Google Cloud Console.
-
In Redirect URI, enter a loopback URI, for example http://127.0.0.1:9004 or http://localhost:9004.
-
Leave Authorization code empty and run the Job once.
-
In the Run console, copy the authorization URL and paste it in a web browser.
-
After sign-in and consent, copy the value of the code query parameter from the browser URL.
-
Paste this value in Authorization code, then run the Job again.
For redirect URI options, see redirect_uri parameter and Loopback IP address in Google documentation.
After the authorization flow succeeds, you can run the Job without repeating the full browser authorization sequence unless the OAuth configuration changes.