To specify a connection to BigQuery, you’ll need to generate a service account
keyfile, then pass the path to that file to your config.yml file, as shown below:
On the Service accounts page, choose your project and click the button that says “Create Service Account”.
Choose a service account name and click “Create and continue”.
Under “Select a role”, choose “BigQuery” and choose an appropriate role for your service account. As this will only be used locally by you, we generally recommend using the most permissive role, BigQuery Admin. Complete the creation of your service account.
On the Service accounts page, select the service account you created and click on the ellipsis under the “Actions” column. Select Manage keys.
On this next page, click Add key > Create new key. Select JSON in the modal and click “Create”. The key will be automatically downloaded in your browser.