Skip to main content

BigQuery

BigQuery is Google Cloud's fully managed, serverless data warehouse that enables super-fast SQL queries using the processing power of Google's infrastructure. It is designed for analyzing large datasets quickly, making it an ideal choice for business intelligence, data analytics, and machine learning workloads.

BigQuery provides a scalable and cost-effective solution for storing and analyzing your data.

  • Offers serverless architecture with automatic scaling to handle petabyte-scale data.
  • Provides real-time analytics with streaming inserts for immediate data availability.
  • Supports standard SQL queries with built-in machine learning capabilities.
  • Integrates seamlessly with other Google Cloud services and popular BI tools.

Getting started

To send data to your BigQuery destination, you'll need:

  • Connection type (Service account)
  • Service Account key file (.json format)
  • Project ID of your Google Cloud project

Configuration

Add BigQuery as a destination to Boltic in the following manner:

To connect with BigQuery

  1. Enter a Destination Name by which you want to refer to this BigQuery Destination
  2. Select Connection type as "Service account"
  3. Upload your Service Account key file (only .json file is allowed)
  4. Enter your Google Cloud Project ID
  5. Test and Save your destination

You have now successfully added BigQuery as a destination to Boltic! Your defined events will start flowing to your BigQuery dataset.