Please note that our BigQuery destination is currently in open beta. The information in this article is subject to change.
The next step to setting up BigQuery is to create a Google Cloud Platform (GCP) account (if you don't already have one) and a Project.
Creating a GCP Account
This one's easy. Simply sign up here and you'll receive a $300 credit.
Creating a GCP Project & Enabling Billing
Next, create a new Project to house your BigQuery data warehouse by following these instructions.
Be sure to enable billing for the account, even if you're using the free trial option. If billing isn't enabled, Stitch will encounter issues when loading data into your data warehouse.
Granting User Permissions
- After the Project has been created, open the Project in the GCP console. You can toggle between/select Projects by clicking the drop-down menu next to the Google Cloud Platform logo in the upper-left corner.
- Navigate to the IAM & Admin page. This can be accessed by clicking Utilities & More (the three vertical dots next to your profile picture in the upper-right corner), then Project Settings:
- The permissions for the Project will display. In the list, locate the user you created.
- Click where it says Owner to open the Roles menu.
- Click BigQuery. An additional menu will display.
- In the BigQuery Roles menu, select BigQuery Admin. The setup should look like this so far:
- In the main Roles menu, scroll down to Storage and click this option. An additional menu will display.
- In the Storage Roles menu, select Storage Object Creator and Storage Object Viewer. The setup should look like this:
- Click Save.
Now that the GCP user is configured, you're ready to hook up your BigQuery instance to Stitch.
Step 3: Connecting BigQuery to Stitch