GCP
Export Cloud Billing data to BigQuery
Google Cloud Platform provides a service called "BigQuery" which enables to export detailed Google Cloud billing data to a Bigquery dataset.
a. Create Billing Account
Log into GCP console portal(https://console.cloud.google.com/) and it will navigate to OverView Tab.
At the top left corner, find an option to create a Project which helps to monitor multiple Billing Account. Select either an already existing project or create new as needed.
Give a friendly Project name and create the Project.
Once Project is created, navigate to "IAM & Actions" -> "Service Accounts" found at the top left corner navigation options.
On navigating to Service Account page, you will find a list of Billing Accounts monitored under the single Project.
Create new Billing Account (Service Account).
Give a friendly name for the service account and create it.
To have access to a more comprehensive set of Google Cloud billing data for the analysis needs, it is recommend to enable Cloud Billing data export to BigQuery at the same time as Billing Account creation.
Navigate to "BigQuery" -> "Data Transfers" at the navigation bar.
Enable the Bigquery Data Transfer to access the bigquery SQL Workspace to get the cost export data.
Creating a GCP Connection
To create a new connection, follow these steps:
Log in to Hybr Admin portal and navigate to Reporting → Data Source -> Connections page.
List of connection created will be listed in Connection tab.
Create a GCP Connection using Create Connection button.
Select Connection category as "GCP".
Give a friendly connection name to the GCP connection.
Provide necessary connection details asked in the second step for Gcp Connection Creation.
Configure the Cost export start date, which ensures from when the cost export records should be collected for individual connection.
Save the changes.
Editing a GCP Connection
If you want to make changes to an existing connection, follow these steps.
Log in to Hybr Admin portal and navigate to Reporting → Data Sources -> Connections page.
Select the connection and click on the "Edit" button
Make the desired changes to your connection.
Save your changes.
Last updated