Activate BigQuery

Summary

1. BigQuery Service Activation
2. Generate an API Access ID

Details

1. BigQuery Service Activation

1. Log in to Google APIs Console.
2. Create a new Google APIs Console project or use an existing project.
3. Navigate to API Services table.
4. Click on Services on the left-hand sidebar.
5. Turn on BigQuery.
6. If prompted, review and agree to Terms of Service.

That should be enough to get started. Refer to the official sign up documentation for comprehensive details.

2. Generating API Access ID

Google APIs use the OAuth 2.0 protocol for authentication and authorization. There are many possible scenarios for using OAuth including Login, Web Server Applications, Client-side Applications, Installed Applications, Devices, and Service Accounts. Refer to the official OAuth2 documentation for complete details.

The Jaspersoft-BigQuery connector uses the Service Account scenario. Therefore you must obtain a Client ID and a private key. The connector uses this information to authenticate with BigQuery. The steps are the following:

1. Navigate to the API Access on the left-hand sidebar in the Google APIs Console.
2. Create an OAuth Client ID.
3. Download the private key.
4. You need the following to use these credentials:
   • Private key
   • Email address
   • Project ID

You can find project ID in the url of the Google APIs Console:

Refer to the official sign up documentation for comprehensive details.