<--- Back to all connectors

BigQuery

Stream data to Google BigQuery in real-time with sub-second latency. Continuously sync your databases to your BigQuery data warehouse.

BigQuery

Stream Data to BigQuery in Real-Time

Key Features

  • Real-time Streaming - Deliver data to BigQuery with sub-second latency
  • Automatic Schema Management - Schema changes are automatically propagated
  • Merge Upserts - Efficiently handle updates and deletes with BigQuery’s merge capability
  • Cost Optimized - Streaming inserts reduce query costs

How It Works

Streamkap streams data directly to BigQuery using the streaming API. This means:

  1. Data arrives in BigQuery within seconds of the source change
  2. No staging areas or intermediate storage required
  3. Automatic handling of schema evolution
  4. Support for soft and hard deletes

Getting Started

  1. Create a BigQuery dataset and service account
  2. Configure your source database connection
  3. Set up your BigQuery destination in Streamkap
  4. Start streaming in minutes

Supported Features

  • All BigQuery editions
  • Partitioned and clustered tables
  • BigQuery Storage Write API
  • VPC Service Controls
  • Customer-managed encryption keys (CMEK)

Why Streamkap?

Reliable

Serverless platform providing enterprise reliability and scale.

Affordable

Only pay for GB into Streamkap.

Longterm

Retain data for as long as you need.

Flexible

Read once, write to many destinations.