​
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

​
Allowlisting Explo’s IPs

You may need to allowlist egress IPs for your Connectivity Region.

​
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.

​
Troubleshooting

  1. If you are getting 403 Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials.

Check out this response from Google’s support team. This has solved previous issues!

​
Questions?

Please reach out to the Explo team at [email protected] if you have any questions.

Azure SQL DBClickhouse