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.
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.
| Related | Troubleshooting |
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.