To get started, you need to

Create a Google Cloud Service Account

1

Navigate to the Google Cloud service account management dashboard and select your project.

2

Click + CREATE SERVICE ACCOUNT

3

Fill in the service account name field. Ex: definite-bigquery-reader

4

Click Done

Grant Bigquery Permissions

1

Navigate to the Google Cloud IAM-Admin console for your project.

2

Click + GRANT ACCESS under the search box.

3

Enter the previously created service account name in the New Principals field. Ex: definite-bigquery-reader .

5

Click Save .

Create And Save the Service Account Key

1

Navigate to the Google Cloud service account management dashboard and select your project.

2

Click on the service account you created.

3

Navigate to the KEYS tab.

4

Click Add Key Create new key Create

  • This will create and download a JSON key (.json) used by Definite to authenticate as the service account user.
5

Save the .json key file

Give Definite the Service Account Key

1

From the Definite homescreen Settings Integrations BigQuery.

2

You should see a screen like this where you can paste in your service account key:

3

Click 'Save'

Public Datasets

You can query BigQuery public datasets. For example:

select
FORMAT_TIMESTAMP('%Y-%m-%d', timestamp) as dt,
*
FROM `bigquery-public-data.hacker_news.full` as c
where c.timestamp >= '2022-11-15'
limit 100