BigQuery

Use this guide to configure your Google BigQuery source in Neo. With just a few key fields and a service account JSON, you’ll be ready to start querying and syncing data from your GCP project.

Getting Started

To connect BigQuery to DataChannel, you’ll need:

  • Your GCP project ID

  • The target dataset ID

  • A service account JSON key

  • Optionally, the location of your BigQuery resources

Connection Details

Here’s what each field means and how to fill it:

1. Name

A unique identifier for this BigQuery connection.

This will help you recognize it when managing multiple sources.

Example:

  • bigquery-prod

  • marketing-analytics

  • gcp-event-logs

2. Project ID

Your Google Cloud Project ID where the BigQuery datasets live.

You can find this in your GCP console under IAM & Admin → Settings.

Example:

my-gcp-project-123

3. Dataset ID

The specific BigQuery dataset you want to connect to.

Example:

  • ecommerce_data

  • user_events

  • marketing_metrics

4. Location

The geographical location of your BigQuery dataset (e.g., US, EU).

Default is US. Only update this if your dataset resides elsewhere.

Authentication

BigQuery uses Service Account authentication.

Service Account Auth

To authenticate, you’ll need to provide the full contents of your service account JSON.

Service Account JSON:

Paste the entire content of the JSON key file you downloaded from GCP.

This includes your client_email, private_key, project_id, etc.

You can create this file by:

  1. Going to IAM & Admin → Service Accounts in the GCP Console.

  2. Selecting or creating a service account.

  3. Granting it access to BigQuery.

  4. Generating a new key and downloading the JSON file.

The JSON will be stored securely and used to programmatically access BigQuery on your behalf.

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.