Skip to main content

BigQuery Database Connector

BigQuery is a cloud-based data warehouse designed for massive-scale analytics with SQL querying capabilities.

info

For the common steps on adding connectors in Unstract, see Working with Connectors.

Getting started with BigQuery​

  1. Create BigQuery account
  2. Create project img BigQuery create project img BigQuery create project 2
  3. Create studio img BigQuery create project 2
  4. Create Dataset img BigQuery create project 2
  5. Set neccessary permissions if required img BigQuery create project 2 img BigQuery create project 2
  6. Create Keys and download Credentials json img BigQuery key creation configuration

Adding BigQuery Connector in Unstract​

When configuring the BigQuery connector, you'll need to provide the following connection details:

Required Configuration Fields​

  • Name of the connector: Enter a descriptive name for your BigQuery connector
  • Credentials: Paste the service account JSON credentials created in Google Cloud

BigQuery Connector Filled

Credentials Format​

The BigQuery connector requires a service account JSON key file with the following structure:

{
  "type": "service_account",
  "project_id": "your-project-id",
  "private_key_id": "key-id",
  "private_key": "-----BEGIN PRIVATE KEY-----\n...\n-----END PRIVATE KEY-----\n",
  "client_email": "service-account@your-project.iam.gserviceaccount.com",
  "client_id": "123456789",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token"
}

Refer to the Google Cloud documentation for detailed instructions on creating service account credentials.