# Google BigQuery (v2) Destination Documentation

## Getting started

[Connecting a Google BigQuery (v2) Destination to Stitch](https://help.qlik.com/en-US/stitch/destinations/google-bigquery/v2/connecting-google-bigquery-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](https://help.qlik.com/en-US/stitch/destinations/google-bigquery/v2/migrating-from-google-bigquery-v1)

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](https://help.qlik.com/en-US/stitch/destinations/google-bigquery/understanding-stitch-impact-on-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](https://help.qlik.com/en-US/stitch/destinations/google-bigquery/apply-table-partitioning-clustering)

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](https://help.qlik.com/en-US/stitch/replication/loading/google-bigquery-storing-nested-data-structures)

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

[Querying Append-Only Tables](https://help.qlik.com/en-US/stitch/replication/loading/querying-append-only-tables)

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

## Troubleshooting

[Destination Loading Error Reference](https://help.qlik.com/en-US/stitch/troubleshooting/destinations/destination-loading-error-reference) Resolve errors related to loading data into your Stitch destination.

[Destination Connection Error Reference](https://help.qlik.com/en-US/stitch/troubleshooting/destinations/destination-connection-error-reference) Resolve errors related to connecting to your Stitch destination.

## Reference

[Google BigQuery v2 Destination Reference](https://help.qlik.com/en-US/stitch/destinations/google-bigquery/v2/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](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides/google-bigquery/v2)

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

[Destination & Integration Compatibility](https://help.qlik.com/en-US/stitch/destinations/destination-integration-compatibility)

Verify your integrations’ compatibility with your data warehouse.

[Stitch System Table and Column Reference](https://help.qlik.com/en-US/stitch/replication/loading/system-tables-columns)

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](https://help.qlik.com/en-US/stitch/replication/loading/reserved-keywords)

A reference of Stitch and destination-reserved keywords.

[Primary Key System Table Reference (_sdc_primary_keys)](https://help.qlik.com/en-US/stitch/replication/loading/system-tables-columns/primary-keys-system-table)

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.