Connect to BigQuery

Steps to prepare and connect to BigQuery

Lightup account setup: BigQuery

• You'll need a service account with a JSON key.

• The account will need three roles:

  • BigQuery > BigQuery Data Editor

  • BigQuery > BigQuery Job User

  • BigQuery > BigQuery Read Session User

Create a service account and download the JSON credentials certificate

You must have Google Cloud admin permissions to create a service account. Google has documentation on creating a service account and generating a private key.

1. Open the credentials page in the Google Cloud Platform API Manager and, if necessary, select your project:

2. Click CREATE CREDENTIALS and choose Service account:

   

3. Enter a name for the new service account, optionally add a description, and click CREATE:

   
4. Your service account requires three Google BigQuery predefined roles:

   • BigQuery > BigQuery Data Viewer

   • BigQuery > BigQuery Job User

   • BigQuery > BigQuery Read Session User

   Select the first role in the Select a role field, then click ADD ANOTHER ROLE and select the next role:

   Repeat to add the third role, then click CONTINUE.

   
5. Click CREATE KEY:

   
6. Select JSON and click CREATE:

   
7. The JSON key will be saved to your computer. BE SURE TO REMEMBER WHERE IT IS SAVED. After noting the download location, click CLOSE:

   
8. At the bottom left, click DONE.

Connector settings

Do either of the following:

• Drag the service account key file to the Upload tab; or select BROWSE on the Upload tab and then browse to and select your key file.

• Open the key and copy/paste its JSON code into the JSON tab.

Read about BigQuery service account keys.