Skip to main content

Connect your GCP account to Holori

To retrieve your billing info and understand your infrastructure, Holori needs to be granted an access to your GCP account. This procedure is made in full compliance with GCP's access rules, please refer to their corresponding documentation using the link at the bottom of the page. We will guide you step by step through this configuration process.

Step 1: Create a new Service Account

1- Log in to your GCP console and make sure that you open the project you want Holori to have access to.

Screenshot

2- Create a service account:

  • To create a service account, select "IAM" then "Service Accounts" in the left panel.

Screenshot

  • On the left panel, select "Service Accounts", then on top of the page select "+ Create Service Account"

Screenshot

  • Give your account a name, an ID and a description (optional)

Screenshot

  • Select "Create and continue"

3- Grant a read-only access right to your acount:

  • You should now have reached the "Grant this service account access to project" part.

  • Click on "Select a role", then scroll to "Project" and select "Viewer" on the panel opening on the right.

Screenshot

4- Once back on the "Service Accounts" page, open the service account you just created

5- To create a JSON key:

  • Open the "Key" section, "Add key" and "Create new key"

Screenshot

  • Create a JSON key

Screenshot

  • Download the JSON key

6- To add your GCP service account to Holori:

  • In Holori App, click on your username at the bottom left of the page, then select the ""Integrations" tab and click on "+Connect now" under the GCP logo.

Screenshot

Screenshot

  • Then upload your JSON file by clicking on "Pick the key file"
  • Write down your Project ID

Step 2: Enable the BigQuery Data Transfer Service API

  1. On GCP Console, go to the API page: https://console.cloud.google.com/apis/api/bigquerydatatransfer.googleapis.com/metrics
  2. On the top left of the page, select your project
  3. On top of the BigQuery Data Transfer Service API page, click "Enable"

Screenshot

Step 3: Create a BigQuery dataset

  1. Go to the BigQuery console and make sure that your project is selected: https://console.cloud.google.com/bigquery
  2. Next to the Project ID, click the View actions menu (the 3 dots one above another) and then click on "Create dataset". The Create dataset panel opens.

Screenshot

  • Enter the following Dataset ID: "all_billing_data"
  • Select a Data location. The Data location specifies the multi-region or region where your data is stored
  • Ensure that the Enable table expiration option is unchecked
  • In the Advanced options section, ensure that the selected Encryption setting is Google-managed encryption key
  • To save, click Create dataset

Screenshot

Step 4: Enable Cloud Billing export to the BigQuery dataset

  1. In the Google Cloud console go to the Billing export page and verify that your project is correctly selected: https://console.cloud.google.com/billing/export
  2. For the "Standard usage cost" and "Detailed usage cost", click on "Enable" if not already done.

Screenshot

Once you have performed the 4 steps, on Holori App, click Save at the bottom of GCP integration page. Your account will be synchronized in the following minutes. Go grab a coffee and start exploring your cost and infra.

info

If your organization has multiple billing accounts, you will need to complete the process above for each account.

Here is the link to GCP's official documentation regarding the creation of a service account: https://cloud.google.com/iam/docs/service-accounts-create

And for setting up the Big Query Data export: https://cloud.google.com/billing/docs/how-to/export-data-bigquery-setup#api