BigQuery

Steps to prepare and connect to BigQuery

Lightup account setup

  • 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:
2784
  1. Click CREATE CREDENTIALS and choose Service account:
2784
  1. Enter a name for the new service account, optionally add a description, and click CREATE:
2784
  1. 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.

2276
  1. Click CREATE KEY:
2274
  1. Select JSON and click CREATE:
1082
  1. The JSON key will be saved to your computer. BE SURE TO REMEMBER WHERE IT IS SAVED. After noting the download location, click CLOSE:
1554
  1. At the bottom left, click DONE.

Connector setting

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.

Schema scan frequency

You can adjust how often scans run for a datasource.

  • In section 3 - Advanced, select a value for Schema scan frequency: Hourly, Daily, or Weekly.

Query governance

BigQuery datasources support the Query history, Scheduling, and Enable data storage settings. For steps, see Set query governance settings for a datasource.