Google BigQuery¶
Supported authentication¶
- OAuth
Prerequisites¶
The following is required before connecting to Google BigQuery in DataRobot:
- A Google account authenticated with OAuth
- A Google BigQuery project
Set up a connection in DataRobot¶
When connecting with OAuth parameters, you must create a new data connection.
To set up a data connection using OAuth:
-
Follow the instructions for creating a data connection—making sure the minimum required parameters are filled in—and testing the connection.
-
After clicking Test Connection, a window appears. Click Sign in using Google.
-
Select the account you want to use.
-
To provide consent to the database client, click Allow.
If the connection is successful, the following message appears in DataRobot:
Required parameters¶
The table below lists the minimum required fields to establish a connection with Google BigQuery:
Required field | Description | Documentation |
---|---|---|
Projectid |
A globally unique identifier for your project. | Google Cloud documentation |
Learn about additional configuration options for Google BigQuery in the installation guide under "Connector Configuration Options".
Caveats¶
- You cannot use multiple Google accounts to authenticate Google BigQuery in DataRobot. Once a Google user is authenticated via OAuth, that Google account is used for all the BigQuery data connections for that DataRobot user.
- DataRobot does not support
Service Account
as the authentication method (except for batch predictions). For more information, contact your DataRobot representative. - If your Google account has a large number of projects, it may take a long time to list schemas, even if the project is filtered with the
projectID
parameter.
Troubleshooting¶
Problem | Solution | Instructions |
---|---|---|
When attempting to execute an operation in DataRobot, the firewall requests that you clear the IP address each time. | Add all whitelisted IPs for DataRobot. | See Source IP addresses for whitelisting. If you've already added the whitelisted IPs, check the existing IPs for completeness. |
Issue authenticating Google BigQuery Need to reset the Google user assigned to authentication |
Locate and remove the bigquery-oauth credential. |
|
Issue authenticating Google BigQuery | Remove authentication consent in Google Cloud console. |
|