Configure BigQuery OAuth
Paradime supports OAuth authentication with BigQuery. When BigQuery OAuth is enabled, users can authorize their Development credentials using Single Sign On (SSO) via BigQuery.
If BigQuery is setup with SSO through a third-party identity provider, developers can use this method to login to BigQuery and authorize the dbt™️ Development credentials without any additional setup.
pageBigQuery connectionCreating a BigQuery OAuth 2.0 client ID and secret
To enable OAuth, you will need to create a Client ID and Secret to authenticate with GCP and manage the OAuth connection between Paradime and BigQuery.
In the Big Query Console, navigate to APIs & Services and select Credentials. If you haven't already, you will need to set up an OAuth consent screen then click on + Create Credentials in the top navigation bar and select from the menu OAuth client ID.
Required Configurations
Use the below configurations to set up the BigQuery OAuth app and click on the Create button. You will generate the Client ID and Secret, that will be required to connect Paradime to your BigQuery account.
| Config | Value |
|---|---|
APPLICATION TYPE | Web application |
NAME | paradime |
AUTHORIZED JAVASCRIPT ORIGINS | Required. Use the correct domain, you can check your selected region during onboarding in the Workspace Management section of your Account Settings.
🇪🇺 eu-west-2 (Europe - London)
|
AUTHORIZED REDIRECT URIs | Required. Use the correct domain, you can check your selected region during onboarding in the Workspace Management section of your Account Settings.
🇪🇺 eu-west-2 (Europe - London)
|
OAuth 2.0 Scopes for Google APIs
Paradime BigQuery OAuth app will request the below scopes:
https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/drive.readonlyhttps://www.googleapis.com/auth/devstorage.read_only
Last updated