Bigquery

BigQuery is a fully-managed, serverless data warehouse that enables fast SQL queries and analytics on large datasets.​⬤

Configuration

Name	Required	Description
Database Location	Yes	US or EU data residency
Access Key	Yes	Google Service Account JSON for BigQuery

Guide to Create a Service Account Access Key

1. Create a Service Account

1. Go to the IAM & Admin Console:

   • Navigate to the IAM & Admin page in the GCP Console.

2. Create a New Service Account:

   • Click on Service Accounts in the left-hand menu.

   • Click + CREATE SERVICE ACCOUNT at the top of the page.

3. Service Account Details:

   • Name your service account: Provide a name and an optional description.

   • Click Create and Continue.

2. Grant BigQuery Permissions to the Service Account

1. Assign Roles:

   • In the Grant this service account access to project section, add the following roles:

     • BigQuery Data Editor: This role allows read and write access to BigQuery tables.

     • BigQuery User: This role allows the creation of new datasets.

2. Finish Creating the Service Account:

   • Click Continue to skip the optional steps (granting users access to this service account).

   • Click Done to finalize the creation of the service account.

3. Create and Download the Service Account Key

1. Select the Service Account:

   • Click on the service account you just created to open its details.

2. Create a Key:

   • Go to the Keys tab and click Add Key > Create New Key.

   • Select JSON as the key type.

   • Click Create to download the key file to your machine. This JSON file contains the credentials you'll use to authenticate with GCP.

   • Paste it into your Evefan Bigquery Destination in the access key field