Skip to main content

BigQuery

BigQuery is Google Cloud's serverless, highly scalable enterprise data warehouse designed for fast analytics and machine learning workloads.

Supported Versions and Architectures​

  • Version: Google Cloud BigQuery (cloud service)
  • Architecture: Serverless, fully managed

Supported Data Types​

CategoryData Types
Numeric TypesINT64, NUMERIC, FLOAT64, BIGNUMERIC
String TypesSTRING
Date & Time TypesDATE, DATETIME, TIME, TIMESTAMP
Boolean TypeBOOL
Binary TypeBYTES
Structured TypesARRAY, STRUCT

Quick Setup Guide​

1. Create IAM Role​

Create a custom role in Google Cloud Console with these permissions:

  • bigquery.datasets.*
  • bigquery.jobs.*
  • bigquery.tables.*
  • bigquery.routines.*

2. Create Service Account​

  1. Go to Google Cloud Console → IAM & Admin → Service Accounts
  2. Create new service account
  3. Assign the custom BigQuery role
  4. Generate JSON key file

3. Create Dataset​

Create a BigQuery dataset with multi-region location for optimal performance.

Limitations​

  • Regional considerations: Use same region as your Mirror Engine for best performance
  • Authentication: Requires Google Cloud service account with proper IAM permissions