BigQuery and Google Cloud Storage
If you want to use BigQuery and Google Cloud Storage for your data warehouse, you need the following prerequisites:
- A Google Cloud Project with billing enabled (opens in a new tab)
- The BigQuery API enabled in your Google Cloud Project
- The Cloud Storage API enabled in your Google Cloud Project
Create a service account
Y42 needs a service account to establish a secure connection to Google Cloud. In the Google Cloud Platform console, navigate to the IAM & Admin section and select Service accounts. Provide the following configuration values (or similar):
| Configuration option | Value |
|---|---|
| Service account name | Y42 |
| Service account ID | Default (auto-generated) |
| Service account description | Service account used by Y42 to read/write to BigQuery and Google Cloud Storage |
Grant service account access
Required service account access roles in Google Cloud.
In the next section, grant the service account access to your Google Cloud project with the following roles:
BigQuery AdminStorage Object AdminStorage Admin
Add a service account key
Add a service account key in Google Cloud.
Select the service account and add a new JSON-formatted key. Download the JSON file.
Connect Y42
Back on Y42, select BigQuery as the provider and upload the service account key.
Choose a hosting location
Choose a location or region where Y42 will create a Google Cloud Storage bucket and a BigQuery dataset.
Minimum required permissions
To run Y42 with minimal permissions within your Google Cloud Project, create a custom role with the following policies. Assign this custom role to the service account you have created, replacing the three ... Admin roles.
Up next
You can now continue with configuring the Git repository for your Y42 space.