To connect Datafold to your BigQuery project, you will need to create a service account for Datafold to use.

  1. Navigate to the Google Developers Console. Before proceeding, click on the drop-down to the left of the search bar and select the project to which you want to connect:

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/2dbe2409-53b0-425e-9e46-e5b09fe1ab79/Untitled.png

NOTE: If you do not see the project you would like to connect to listed in the drop-down, click on the account switcher in the upper right corner of the window and ensure you are logged in to a Google account that is a member of the project.

  1. Click on the hamburger menu in the upper left and select IAM & Admin and then Service accounts.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/122f0747-a936-4e0f-ac9a-cacb0357c49d/Untitled.png

  1. Click Create New Service Account button and give it a name:

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/b0c3664b-0bb6-4135-8a0c-1dcf6c47a213/Untitled.png

  1. Under Project Role, add BigQuery Job User and BigQuery Data Viewer roles:

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/12dcf4dd-36b8-4a2e-8486-aa123d72c810/Untitled.png

  1. On the next screen, select to create a new JSON key for your service account. You will use it for creating BigQuery connection in Datafold:

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a927926d-fd3d-4e24-bed0-6fb83b7cb0c6/Untitled.png

  1. Create a dataset "datafold_temp" that will be used by Datafold for materializing intermediate results and to improve performance of the analysis.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/6040790f-0fb1-4930-9c4d-8fcf525e07c6/Untitled.png

  1. Grant the newly created service account BigQuery Data Owner role in the "datafold_temp" dataset:

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/8ad0b31c-e7d9-4dac-af5d-c46b3227498c/Untitled.png