Google Cloud

Vantage uses a service account to integrate with your GCP account. The service account is generated on a per-customer basis. Vantage requests extremely basic and limited permissions for GCP. During the integration process, you will grant the service account access only to the specific BigQuery dataset that contains your billing data.

Prerequisites

Before you start the integration process, you will need to complete the following prerequisites:

• Create a project to store your Cloud Billing export data.
• Create a BigQuery dataset to store your Cloud Billing export data.
• Enable Cloud Billing export.

See the GCP Cloud Billing export instructions for details on how to complete the above steps. Then, return to this page to complete the rest of the integration process.

note

If your organization enforces domain restrictions, you can add the following Google Cloud organization ID to allow Vantage access: 421856710303. If you instead need the customer ID, use C03l99qsz.

If you have a pre-existing Cloud Billing export set up, ensure your configuration adheres to the requirements below before moving further.

• Your project is linked to the same Cloud Billing account that the Cloud Billing export is enabled on.
  tip

  We recommend you create a dedicated project to store all Cloud Billing data, rather than using an existing project.

• Detailed Billing Export is enabled, not Standard Billing Export.
• The BigQuery dataset and table are deployed to either US (multiple regions in United States) or EU (multiple regions in European Union).
• If you have multiple Cloud Billing accounts, you will need to enable Cloud Billing exports on each account.

note

If your GCP billing data is typically displayed in a currency other than USD, Vantage will convert it to USD using the currency_conversion_rate field in the Cloud Billing export data.

Create a Connection

Open a new browser tab, and navigate to the Vantage GCP Settings page. You should see your customer-specific service account displayed at the top of the integration page. Keep this page open.

Step 1: Grant the Vantage Service Account Permission to Access BigQuery and Active Resources

Back in GCP, navigate to the IAM console, and complete the steps below to grant the Vantage service account permission to access BigQuery. To enable active resources, you must also grant the Viewer role to the Vantage GCP service account. This role allows read-only access to all resources in the project, enabling Vantage to gather data on active resources.

info

For a list of all supported GCP active resources, see the GCP Supported Services documentation.

1. At the top of the IAM console, select the project that hosts the BigQuery dataset with your Cloud Billing export data.

2. Configure the following permissions:

   • In the center of the page, under Permissions for project "My Project ABCD", click + GRANT ACCESS.
     Expand to view example image

     
   • In the New principals field, under Add principals, paste the value for your Vantage service account. This value is the one displayed on the Vantage GCP Integration page you opened earlier.
   • In the Role field, under Assign roles, search for and select BigQuery Job User.
   • Click + ADD ANOTHER ROLE.
   • Under Assign roles, click Basic and select the Viewer role from the Role list. This adds the role needed for active resources.
     Expand to view example image

     

3. Click SAVE.

Step 2: Grant the Vantage Service Account Permission to Access the BigQuery Dataset

Go back to BigQuery, and complete the steps below to grant the Vantage service account permission to access the BigQuery dataset.

1. At the top of the BigQuery console, ensure the project that you set up to contain your billing data is selected.
2. In the Explorer panel, select your project to expand it.
3. Select the three vertical dots next to the dataset name, then click Open. The Dataset info will be displayed on the right. Keep this screen open to later obtain your project ID and dataset name.
4. Select the three vertical dots next to the dataset name again, then click Share.
   Expand to view example image

   

   In this example, project-id-123456 is the project and all_billing_data is the dataset.

5. On the Share permissions panel that appears on the right, click + ADD PRINCIPAL.
6. In the New principals field, under Add principals, search for and select the Vantage service account.
   tip

   Copy the full name of your service account from the Vantage console into the search field to search for it.

7. In the Role field, under Assign roles, search for and select BigQuery Data Viewer.
   Expand to view example image

   
8. Click SAVE.

Step 3: Add Your GCP Configuration Information to the Vantage Console

Keep BigQuery open in one of your browser tabs. Go back to the Vantage GCP Integration page to complete the integration process.

1. At the bottom of the Vantage GCP Integration page, click Add Project Info. A pop-up is displayed, which requires your Billing account ID, the project ID for the project that hosts the BigQuery dataset, and the BigQuery dataset name.
2. To obtain your Billing Account ID:
   • Go to GCP Billing.
   • Copy the value for your billing account, displayed in the Billing account ID column. It will look something like 1234AB-123456-7ABC12.
     Expand to view example image

     
3. To obtain your Project ID hosting BigQuery dataset and BigQuery Dataset Name:
   • In the Dataset info screen of BigQuery (previously opened in step 3 of the last section), observe the value on the Dataset ID line.
     Expand to view example image

     
   • Copy everything before the period. For example, in project-id-123456.all_billing_data, copy only project-id-123456. Paste this in the Project ID hosting BigQuery dataset field in Vantage.
   • Copy everything after the period and paste it in the BigQuery Dataset Name field in Vantage. (For example, in project-id-123456.all_billing_data, copy all_billing_data.)
     Expand to view example image

     
4. Click Connect Account.

Important

It typically takes a few hours for data to start appearing. Cloud Billing data is added retroactively for the current and previous month when detailed usage cost data is configured. Full data for the current and previous month can take 24–48 hours to fully propagate.

Next Steps: Manage Workspace Access

Once your costs are imported, select which workspaces this integration is associated with. See the Workspaces documentation for information.

Data Refresh

See the provider data refresh documentation for information on when data for each provider refreshes in Vantage.

Reporting Dimensions

On GCP Cost Reports, you can filter across several dimensions:

• Project (project name)
• Category (e.g., Cloud Functions Invocations (2nd Gen))
• Label/Not Labeled (includes GCP labels and virtual tags created in Vantage for this provider)
• Resource (resource ID)
• Region (e.g., Us East1)
• Charge Type (e.g., Usage)
• Billing Account (billing account ID)
• Marketplace (Toggle to show only Marketplace purchases or excluded)
• Service (e.g., Cloud Build)