Skip to content

Connecting to Google BigQuery

To connect to Google BigQuery, select Google BigQuery from the Database dropdown on the connection tab.

Connection information

Your connection details

You will need to provide several pieces of information. You may need to retrieve this information from your system administrator.

JSON Private Key

Supply a private key in the form of a JSON-formatted string. To create a private key, create a service account and generate a JSON private key through the Google console. The service account should be restricted to the minimal permissions required for your reporting and data access needs. See Security Considerations for more information about how to safely connect to a remote database.

Project ID

Enter the port the project ID corresponding to the Google BigQuery instance you would like to connect to. This field is optional since the JSON Private Key already contains a reference to the default project ID. Enter a project ID here to override the default.

Label Filter

Select tables to be indexed by filtering on labels. The system will inspect the database to reverse engineer table and column information for the dataset and Rational BI limits the number of indexed tables for performance reasons. This setting can be used to ensure that the system only sees a limited number of tables since a long list may be difficult to navigate when building reports. Other areas of the database can still be accessed (if permissions allow) through programmatic cells. See the Google Documentation for more information on filtering.

Testing your configuration

You can test your configuration by pressing the Test Configuration button. Rational BI will attempt to make a connection to the remote database and will indicate if the connection was successful. If an error was reported, check that the supplied information is correct and that no access control lists, firewalls or gateway systems prevent a connection from the Rational BI servers. The right panel contains a list of IPs that should be allowed to connect to the database.

Saving your configuration

When the configuration is correct, press Save. The system will connect to the remote database and create the metadata schema with table and column information based on the tables and views visible to the configured user.

The dataset will be updated to reflect that the remote database is online, and the database connection is now ready for use.