Configure Google BigQuery Accounts

Overview

You must create Google BigQuery Accounts to connect to data sources that you want to use in your pipelines. You can configure your account from SnapLogic Platform using the Designer or Manager.

Snap-account compatibility

Snaps in the Google BigQuery Snap Pack work with different accounts as noted in the following table.

Snaps Google BigQuery Dynamic OAuth2 Google BigQuery OAuth2 Google BigQuery Google Service Account Google Service Account JSON
BigQuery Bulk Load - Cloud Storage Tick Icon Tick Icon Tick Icon Tick Icon
BigQuery Bulk Load - Streaming Tick Icon Tick Icon Tick Icon Tick Icon
BigQuery Bulk Upsert - Streaming Tick Icon Tick Icon Tick Icon Tick Icon
BigQuery Execute Tick Icon Tick Icon Tick Icon Tick Icon
BigQuery Write Tick Icon Tick Icon Tick Icon Tick Icon
BigQuery Dataset Create Tick Icon Tick Icon Tick Icon Tick Icon
BigQuery Dataset Delete Tick Icon Tick Icon Tick Icon Tick Icon
BigQuery Dataset List Tick Icon Tick Icon Tick Icon Tick Icon
BigQuery Table Delete Tick Icon Tick Icon Tick Icon Tick Icon
BigQuery Table List Tick Icon Tick Icon Tick Icon Tick Icon
BigQuery Table Create Tick Icon Tick Icon Tick Icon Tick Icon
BigQuery Table Data List Tick Icon Tick Icon Tick Icon Tick Icon

Account encryption

Standard Encryption If you are using Standard Encryption, follow the High sensitivity settings under Enhanced Encryption.
Enhanced Encryption If you have the Enhanced Account Encryption feature, the following describes which fields are encrypted for each sensitivity level selected for this account:
  • High: Access Token, JSON Key
  • Medium: Default Standard SQL
  • Low: Label