Stitch Documentation
has moved!

Please update your bookmarks to

If you're not automatically redirected after 5 seconds, click here.

Step 1: BigQuery Prerequisites

Please note that our BigQuery destination is currently in open beta. The information in this article is subject to change. 

Google BigQuery is a fully managed, cloud-based big data analytics web service for processing very large read-only data sets. BigQuery was designed for analyzing data on the order of billions of rows, using a SQL-like syntax. 

For more information, check out Google's BigQuery overview.

What are the prerequisites?

For security purposes, we recommend setting up a new Google Cloud Platform (GCP) account and project for use with Stitch. The user associated with the account must have:

  • Full access to a GCP project. Stitch requires this permission to create datasets and load data into BigQuery.
  • Admin permissions to a BigQuery instance that has billing info (a credit card) attached to it.
  • Storage Object Creation and Storage Object Viewer roles for Google Cloud Storage (GCS). Specifically, these include the storage.objects.create, storage.objects.get, and storage.objects.list object permissions. Stitch requires these permissions to create and use a GCS bucket to load replicated data into BigQuery.

Even if you're using BigQuery's free trial option, billing must be enabled for your instance. If it isn't, Stitch will encounter issues when loading data into your data warehouse. These instructions will walk you through how to set up and connect a billing account to your BigQuery instance.

We'll go into the setup and permissions required in more detail in the next step.

What do I do now?

After you've completed the prerequisites, you can move onto creating a BigQuery account and project and connecting it to Stitch.

Step 2: Creating a BigQuery account & project

Was this article helpful?
0 out of 0 found this helpful


Questions or suggestions? If something in our documentation is unclear, let us know in the comments!