BigQuery

Overview

This doc outlines how to use the BigQuery integration to create and manage tables in your Cargo.


Setup

Requirements

  • Active Google Cloud Platform (GCP) account
  • BigQuery API enabled
  • Service account with appropriate permissions

Guide

  1. Create a Service Account

    • Go to the Google Cloud Console
    • Navigate to IAM & Admin > Service Accounts
    • Create a new service account with BigQuery permissions
    • Download the JSON key file
  2. Configure Connection

    • Provide the following connection information:
      • Service Account Key: Upload the JSON key file downloaded earlier
    • All information can be found in your Google Cloud Console

Security

  • Service account keys are securely stored and encrypted at rest
  • Data transfer is encrypted using TLS