Select version

For a side-by-side comparison of each version of the Google BigQuery destination, refer to the Version comparison section.

Interested in migrating from v1 to v2? Here’s how.


Version history and changelog

In this section:

  • Overview - All versions for Stitch's Google BigQuery destination, including release and deprecation dates.
  • Changelog - Details about updates to Stitch's Google BigQuery destination.

All versions for Stitch's Google BigQuery destination, including release and deprecation dates.

Version Release date Deprecation date End of life (Sunset)
version v2 (latest) November 19, 2019
version v1 November 3, 2016
Date Version Release notes
November 19, 2019 v2

New version (v2) in beta

A new version of Stitch's Google BigQuery destination has been into beta.

Notable changes from v1 include:

  • Upsert support. Updates can now be made to existing rows in Google BigQuery.
  • Configurable loading behavior. You can now define the loading behavior for Google BigQuery destinations: Upsert or Append-Only. Learn more.
  • Authentication via Service Accounts. This version of Google BigQuery uses a GCP IAM service account to authenticate, instead of OAuth. This disassociates the account used to connect to Google BigQuery from an individual user.
  • No more Google Cloud Storage (GCS) requirements. Stitch now uses an internal GCS bucket for loading, removing the need for you to maintain a bucket for Stitch.
  • API availability. Google BigQuery destinations can now be configured and managed via the Connect API.
  • Expanded GCS region support. Stitch now supports additional GCS regions. Learn more.

Note: This version is not backwards-compatible. While it’s similar to v1, you should expect to spend some time refactoring your analyses after migrating.

Interested in participating in the beta?

November 3, 2016 v1

New version (v1)

A new version of Stitch's Google BigQuery destination has been released.

Check out the Google BigQuery v1 overview for more info, or set up the destination.


Version comparison

Google BigQuery v2 Google BigQuery v1
STITCH DETAILS
Release status Released Released
Release date November 19, 2019 November 3, 2016
Stitch plan availability

All Stitch plans

All Stitch plans

Connect API availability Supported Unsupported
CONNECTION METHODS
SSH connections Unsupported Unsupported
SSL connections Supported Supported
VPN connections Unsupported Unsupported
REPLICATION AND LOADING
Default loading behavior

Selected by you

Append-Only

Nested structure support Supported Supported
Incompatible sources

None

None

ADDITIONAL FEATURES
Supported GCS regions

17 total. Full list.

6 total. Full list.

Workload and performance management Supported Supported

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.