Stitch Documentation
has moved!

Please update your bookmarks to

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

Step 2: Creating a Google Cloud Platform Account & Project

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

  1. 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.
  2. 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:

  3. The permissions for the Project will display. In the list, locate the user you created.
  4. Click where it says Owner to open the Roles menu.
  5. Click BigQuery. An additional menu will display.
  6. In the BigQuery Roles menu, select BigQuery Admin. The setup should look like this so far:

  7. In the main Roles menu, scroll down to Storage and click this option. An additional menu will display.
  8. In the Storage Roles menu, select Storage Object Creator and Storage Object Viewer. The setup should look like this:

  9. 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 

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!