ePrivacy and GPDR Cookie Consent by Cookie Consent Skip to main content

Loader Google BigQuery

The Google BigQuery Loader job entry enables you to load data into Google BigQuery from a Google Cloud Storage account.

Prerequisite

OAuth

  • Create OAuth client IDs or obtain an existing client id (OAUTH_CLIENT_IDOAUTH_CLIENT_SECRET)
  • Use these client credentials in (https://developers.google.com/oauthplayground)[Google OAuth playground] to create new authorization, use https://www.googleapis.com/auth/bigquery scopeService Account

This app requires 2 sets of service account credentials - one for managing the tests (fixtures, etc), one for running the tests. They have different scopes.

Manage

  • Create a new service account (IAM > Service accounts), e.g. BigQuery Writer Manage
  • Add BigQuery Data Owner and BigQuery Job User roles to the user
  • Create JSON key
  • Remove newlines from the JSON and assign it to the SERVICE_ACCOUNT_MANAGE variable in the .env file

User

  • Create a new service account (IAM > Service accounts), e.g. BigQuery Writer User
  • Add BigQuery User and BigQuery Job User roles to the user
  • Create JSON key
  • Remove newlines from the JSON and assign it to the SERVICE_ACCOUNT_USER variable in the .env file

 

01.png

02.png