Overview

BigQuery API Credentials

What You Need

• A BigQuery service account’s client email and private_key from a Google Cloud JSON key file

How to Get Your BigQuery API Credentials

1. Log in to Google Cloud/Bigquery. Ensure you are in the project you want to query from.

2. Open the Navigation Menu

3. Navigate to APIs & Services -> Credentials

4. Click 'Create Credentials' and create a new Service Account

5. Name your service account, create a service account ID, and click 'Create and continue'

6. Assign the required BigQuery permissions: 

• BigQuery Data Editor
• BigQuery Job User

7. Once you finish setup, you will be brought back to your credentials landing page. Click on your newly created service account

• Open the key tab and click 'Add key'. Choose JSON for key type
• This will prompt a json download, which now contains your service account email and key which are needed for authentication

8. Save the JSON file somewhere securely. You will reference it later to authenticate BigQuery in your integration

Need more help? Please refer to Google Cloud's API documentation here.

Authenticate BigQuery in Alchemer

After obtaining your BigQuery API credentials, add them to the Alchemer BigQuery integration. Credentials are securely stored in Alchemer and can be reused.

How to Authenticate

1. Start a New Authentication

• Inside any BigQuery integration action, select New Authentication.

2. Enter Your BigQuery Credentials

• Your service account's client_email and private_key exactly as they appear in your JSON file
  • When copying the private key, include the entire key exactly as shown in the JSON, including all \n escape characters and the full -----BEGIN PRIVATE KEY----- and -----END PRIVATE KEY----- lines.
  • Exclude the quotation marks around client_email and private_key

3. Save Your Authentication

• Select Create.
• Once created:
  • The authentication is saved and reused for all BigQuery actions
  • You only need to update it if your API credentials change