Skip to content
Infoveave Help

Google BigQuery

Google BigQuery connection helps Infoveave access Google’s scalable cloud data warehouse to query, analyze, and process large datasets efficiently.

Adding a Google BigQuery Connection

To create a new Google BigQuery connection:

  1. Go to Administration > Connections
  2. Click New Connection and select Google BigQuery from the available connectors
  3. In the New Google BigQuery Connection form, choose your preferred authentication method and provide the required configuration details

Connection Parameters

When setting up a Google BigQuery connection, provide the following information:

FieldDescription
NameA unique name to identify your BigQuery connection
Authentication MethodChoose between Auth code (OAuth) or Service account

BigQuery supports two authentication modes in Infoveave, explained below.

Authentication Methods

1. Auth Code (OAuth)

Use OAuth authentication when you prefer signing in with your Google account.

Steps:

  • Click Sign in with Google
  • Choose the Google account that has BigQuery access
  • Authorize Infoveave to access your BigQuery datasets
  • Provide the Project associated with your BigQuery resources

This method is suitable when:

  • You want easy sign-in without service account management
  • You prefer user-level access to BigQuery resources

2. Service Account

Use a service account when you want secure, automated, non-user-based access.

Steps:

  • Select the Service account tab
  • Upload the JSON service account key file downloaded from Google Cloud
  • Ensure the service account has BigQuery access roles (Viewer, Data Viewer, or custom roles)

This method is ideal for:

  • Scheduled automations
  • Server-to-server communication
  • Environments requiring strict credential control

Steps to Validate and Save

  1. After providing authentication details (OAuth or Service account), click Validate to verify the connection
  2. If validation succeeds, click Save to store the connection
  3. You can now use this BigQuery connection as a datasource across Infoveave workflows and dashboards

Example Use Cases

With a Google BigQuery connection configured, you can:

  • Query large datasets directly from BigQuery into Infoveave
  • Build dashboards using data stored in BigQuery tables
  • Automate workflows based on query results or data refresh schedules
  • Combine BigQuery data with CRM, ERP, or API datasets for unified analytics
  • Run complex analytical queries for forecasting or data modeling
  • Visualize multi-terabyte datasets without moving data out of BigQuery