Setup Google Cloud
Connecting Your GCP Billing Account
Vantage integrates with your GCP account through the use of a service account. A service account is generated on a per customer basis and is only granted permissions to read from the specific Big Query table in your account.
Read-Only by Default
The service account is read-only by default. It does not have permissions nor will ever attempt to make any changes to your infrastructure.
Prerequisites
Before you begin, you will need to:
- Enable Billing Export
- Create a project to store your Billing Export data
- Create a BigQuery dataset to store your Billing Export data
If you have a pre-existing Billing Export, double-check the requirements below then skip to the next section. If you need help setting up Billing Export, you can follow the instruction here.
Billing Export Requirements:
- Project is linked to the same Cloud Billing account that Billing Export is enabled on
- Detailed Billing Export is enabled, not Standard Billing Export
- The BigQuery dataset and table is deployed to either
us (multiple regions in United States)
oreu (multiple regions in European Union)
- Note: If you have multiple Cloud Billing accounts, you will need to enable Cloud Billing Export on each one individually.
Recommendation: We recommend that you create a dedicated project to store all Cloud Billing data rather than using an existing project.
Note on Currency: If your GCP billing data is normally displayed in a currency other than USD, we will convert it to USD using the currency_conversion_rate
field in the Billing Export data.
Creating a GCP Data Integration
Now that you have:
- The Billing account ID
- The name of the project
- The name of the Big Query dataset
Create a GCP data integration by logging into your Vantage account and going here. You will be asked to add these inputs into the onboarding flow.
Connecting Manually
Assign Vantage Service Account Permission to Access BigQuery
- Open the IAM Console
- Select the project hosting the BigQuery dataset containing your Billing Export data from the project drop-down in the main navigation bar at top. If you don’t see the project name right away, try the "ALL" tab or search for it
- Add a new permission to the project
- Click the Add button
- Under New principals, add your Vantage service account (found in the GCP onboarding workflow in the Vantage console)
- Attach the role
BigQuery Job User
- Click the Save button
Assign Vantage Service Account Permission to Access BigQuery Dataset
- In the hamburger menu, navigate to BigQuery under ANALYTICS and select SQL Workspace
- Grant Vantage service account access to the BigQuery dataset:
- Select the project name
- Select the dataset by clicking the three vertical dots button and selecting Open
- Click the Share button and select Permissions
- Under New principals, add your Vantage service account
- Attach the role,
BigQuery Data Viewer
- Click the Save button
- Return to the Vantage GCP onboarding workflow and click the Next button
Connecting with Terraform
If you manage your infrastructure with Terraform it is very easy to connect to Vantage. During onboarding, instead of following the manual integration process, you can click on the terraform instructions which will give you the IAM Role creation snippets. This can be dropped into your Terraform codebase. Once this has been deployed you can complete the onboarding workflow.