Getting Started with Google BigQuery

Google BigQuery setup

1. Go to https://console.cloud.google.com.
2. Select your country and agree to the terms of service.
3. Select “BigQuery” from the left menu. Alternatively you can use the search bar.
4. Click the “Create Project” button.
5. Name your project, choose organization if needed.
6. Click “Create”.
7. Click “Enable Billing”.
8. Select “Set Account”.
9. Enter your billing details and ensure billing is enabled on your project.
10. Select “Service Accounts” from the IAM & Admin section of the left menu. You can also use the search bar.
11. Click “Create Service Account”.
12. Enter a name and description for your service account.
13. Under “Select a role” go to “Basic” and click “Owner”.
14. Click “Done”.
15. Select your new service account by clicking its email.
16. Click “Add Key”.
17. Select “JSON”.
18. Save the downloaded file in a secure location. This is the file required for the “Google service account key file” below.