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

22762276
  1. Click CREATE KEY:
22742274
  1. Select JSON and click CREATE:
10821082
  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:
15541554
  1. At the bottom left, click DONE.

Query governance

BigQuery datasources support Query date range limit and Query history. For steps, see Set query governance settings for a datasource.

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.


Did this page help you?