Explo home pagelight logo
Data Source Types
BigQuery

​
Intro

Find out more about BigQuery here.

​
Necessary Credentials

  • Project ID

    • This is the ID of the project

  • JSON Key File

    • This file was given to you when you created the service account

​
Whitelisting Explo’s IPs

You may need to whitelist our Explo IP’s 54.211.43.19, 52.55.98.121, 3.214.169.94,and54.156.141.148

​
BigQuery Credentials

Create a Bigquery service user

  1. In the Cloud Console, go to the Create service account key page.

  2. From the Service account list, select New service account.

  3. In the Service account name field, enter a name.

  4. From the Role list, add the following roles

    1. BigQuery Job User
    2. BigQuery Data Viewer
    3. BigQuery Metadata Viewer

  5. Click Create. A JSON file that contains your key downloads to your computer.

The Role field affects which resources your service account can access in your project. You can revoke these roles or grant additional roles later. For more information, see Granting, changing, and revoking access to resources.

​
Questions?

Please reach out to the Explo team at support@explo.co if you have any questions.