Please note that our BigQuery destination is currently in open beta. The information in this article is subject to change.
To complete the setup, you need to complete the Google authorization process which will grant Stitch access to your BigQuery project.
Authenticating with Google
- To begin, navigate to the Destination Settings page (click your profile icon > Destination Settings) and click the Google BigQuery icon.
- Click the Sign in with Google button.
- If you aren't already signed into your Google account, you'll be prompted for your credentials. Sign into the Google account that you want to use to connect BigQuery to Stitch.
- After you sign in, you'll see a list of the permissions requested by Stitch:
To grant access, click the Authorize button.
- Read/Write Access to Google Cloud Storage - Stitch requires Read/Write access to create and use a GCS bucket to load replicated data into BigQuery.
- Full Access to BigQuery - Stitch requires full access to be able to create datasets and load data into BigQuery.
- Read-Only Access to Projects - Stitch requires read-only access to projects to allow you to select a project to use during the BigQuery setup process.
- Basic Profile Information - Stitch users your basic profile info to retrieve your user ID.
- Offline Access - To continuously load data, Stitch requires offline access. This is so the authorization token generated during setup process can be used for more than an hour after the initial auth.
Connecting a BigQuery Project
The last step in connecting BigQuery is to select the Project you want to use to house your data. After you sign into Google and grant Stitch access, you'll be prompted to select a Project.
Select a Project from the drop-down menu and click the Finish Setup button.
If the connection is successful, a Success! message will display at the top of the screen.
What do I do now?
Now that your data warehouse is set up and connected to Stitch, you can connect your data sources and get the data flowing.
We also recommend checking out the articles in the Related section to get a better understanding of how your data will be stored once Stitch loads it into BigQuery.