Skip to content

Click in-app to access the full platform documentation for your version of DataRobot.

Google BigQuery

Supported authentication

  • OAuth

Prerequisites

The following is required before connecting to Google BigQuery in DataRobot:

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:

  1. Follow the instructions for creating a data connection—making sure the minimum required parameters are filled in—and testing the connection.

  2. After clicking Test Connection, a window appears. Click Sign in using Google.

  3. Select the account you want to use.

  4. 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.

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.
  1. In DataRobot, navigate to the Credentials Management tab.
  2. Select the bigquery-oauth credential and click Delete.
  3. Select User Settings > Data Connections.
  4. Reauthenticate your Google BigQuery data connection.
Issue authenticating Google BigQuery Remove authentication consent in Google Cloud console.
  1. Navigate to your Google Account permissions.
  2. Select DataRobot under third-party applications.
  3. Click Remove Access.

Updated January 26, 2023
Back to top