Getting started

Connecting a Google BigQuery (v2) Destination to Stitch

Connect a Google BigQuery database to your Stitch account as a destination.

Migrating from a Google BigQuery v1 destination to Google BigQuery v2

Migrate from using Stitch’s Google BigQuery v1 destination to the new version, v2.


Using Google BigQuery

Understanding Stitch’s Impact on Google BigQuery Costs

Unlike traditional relational databases and other cloud solutions, Google BigQuery pricing isn’t fixed-rate: it’s based on usage. The goal of this article is to help you better understand how your data warehousing costs will be impacted by using Stitch’s BigQuery destination so you can make an informed decision.

Apply table partitioning and clustering in BigQuery

Want to improve your BigQuery performance and query costs? In this article, we’ll walk you through how to use table partitioning and clustering to streamline query processing in your BigQuery destination.

Understanding Loading for Nested Data Structures in Google BigQuery Destinations

Understand how Stitch loads nested data structures in version 2 of the Google BigQuery destination.

Querying Append-Only Tables

Learn how Append-only Loading works and how to account for it in your queries.


Troubleshooting

Destination Loading Error Reference Resolve errors related to loading data into your Stitch destination.

Destination Connection Error Reference Resolve errors related to connecting to your Stitch destination.


Reference

Google BigQuery v2 Destination Reference

Reference documentation for version 2 of Stitch’s Google BigQuery destination, including info about Stitch features, replication, and transformations.

Google BigQuery (v2) Data Loading Reference

Learn how Stitch will load data from your integrations into version 2 of Stitch’s Google BigQuery destination.

Destination & Integration Compatibility

Verify your integrations’ compatibility with your data warehouse.

Stitch System Table and Column Reference

When data is loaded into your destination, Stitch will create some additional columns and tables. Learn about these system columns and tables and how Stitch uses them.

Stitch and Destination Reserved Keywords

A reference of Stitch and destination-reserved keywords.

Primary Key System Table Reference (_sdc_primary_keys)

Some of Stitch’s destinations don’t have native support for Primary Keys. To ensure data can be de-duped during loading, Stitch will create a Primary Keys table for each integration schema.


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.