Airbyte Connector to BigQuery

Replicate your data in minutes, through our UI or programmatically with our API.

Replicate your data to BigQuery in minutes

The Airbyte BigQuery destination connector allows you to sync data to BigQuery, without the headache of writing and maintaining ETL scripts.

This BigQuery destination is based on the PipelineWise BigQuery Target.

Check our detailed documentation on how to start syncing data to BigQuery.

Features of the connector

Feature
Supported
Full Refresh Sync
Yes

Output schema

Each stream will be output into its own table in BigQuery. Each table will contain 3 columns:

  • ab_id: a uuid assigned by Airbyte to each event that is processed. The column type in BigQuery is String.
  • emitted_at: a timestamp representing when the event was pulled from the data source. The column type in BigQuery is Timestamp.
  • data: a json blob representing with the event data. The column type in BigQuery is String.

Similar connectors

Stay in the know

Get the latest Airbyte news by email, with the latest community contributions, product updates and articles.