PierCloud FinOps Platform - GCP Basic Configurations

Basic Configuration Process for Pier Cloud FinOps Platform

Welcome to Pier Cloud!

This document is intended to be a guide for you to prepare the environment so that Pier Cloud can install the Platform modules in your account.

The entire process will allow Pier Cloud to only read information, without any possibility of changing or deleting data from your account.

Considerations:

The settings will be performed in a single project:

The project should only be created if the client wants a dedicated project for billing. Otherwise, an existing project that has billing enabled can be used, as long as it is able to execute the billing export.

It is important that BigQuery is in the same region as the project, as data transfers between different regions cannot be completed successfully.

The Service Account must be configured in the project where billing export is enabled. If there is no project already created for this purpose, the customer can choose to create a new project that is linked to the Payer account.

Even if only one service account is created, it will be necessary to configure a specific role, which must be attached to the project where the billing export was configured.

Items that will be configured:

1. Service account 1x

2. Role 1x

3. Bigquery 1x

4. Cloud storage bucket 1x

5. Enable detailed billing export to bigquery

Information that must be sent to pier cloud:

1. Credential in .json format

2. Client project id

3. billing account id (can be found in the billing overview in the format: 01D971-641F25-2A6D35)

4. Name of the BigQuery dataset of the project that receives the billing data (by default all_billing_data)

5. Location of bigquery

6. Project bucket name piercloud-billing

Lighthouse

GCP Billing Configuration

1. On the home page in the search field look for Roles as illustrated in the image below:

1. Here click on + CREATE ROLE, as illustrated below:

1. Here in the Title field, add the name: (piercloud-billing-role), for the role, then click on Add Permissions, as illustrated in the image below:

1. Select all permissions from the list below and click Create to complete the role creation:

Permissions that must be added:

• bigquery.datasets.create

• bigquery.jobs.create

• bigquery.tables.list

• bigquery.tables.create

• bigquery.tables.delete

• bigquery.tables.export

• bigquery.tables.getData

• bigquery.tables.update

• bigquery.tables.updateData

• storage.objects.create

• storage.objects.delete

• storage.objects.get

• storage.objects.list

1. Here in the search field, look for service accounts, as illustrated in the image below.

1. Here click on + CREATE SERVICE ACCOUNT, as illustrated in the image below:

1. In the Service Account Details field, enter "piercloud-billing" and click CREATE AND CONTINUE, then click DONE, as illustrated in the image below:

1. Now the Service Account has been successfully created, let's click on the name of the service account to generate the key.

1. Here select the KEYS option, as illustrated in the image below:

1. Here click on ADD KEY, then select Create new key, as illustrated in the image below:

1. Here select the key type with the JSON option, then click Create to download the key:

1. The key has been saved on your computer: *Usually in the Download folder

1. To activate the Billing account, you will need to create a cloud storage, in the search field look for Cloud Storage, as illustrated in the image below:

1. Here click on CREATE BUCKET, as illustrated in the image below:

1. Now add a name for the bucket (piercloud-billing-companyname), then click create, as illustrated in the image below:

1. Here, click on the checkbox (Apply public access prevention to this bucket), then click confirm to create the bucket, as illustrated in the image below.

1. Bucket created successfully! Now we can proceed with the configuration.

1. Here click on the menu on the left as illustrated in the image below:

1. In the menu on the left, select the Billing option, as illustrated in the image below:

1. Here to export billing data to BigQuery, in the left menu click on Billing Export, as illustrated in the image below:

1. Here, to export billing data to BigQuery, you need to enable the Detailed Cost and Usage option. To do this, click on Edit Settings, as shown in the image below:

1. Here click on Dataset, then select the Create new dataset option, and click OK, as illustrated in the image below:

1. Here in the “Dataset ID” field, add the following name “all_billing_data” to create the new dataset and click Create Dataset:

   Note: If the dataset already exists, skip this step.

1. Select the dataset created in bigquery and click Save:

1. The Detailed Usage Cost has been successfully created! Now let's activate the Pricing.

   Note: The Pricing is used by Focus.

1. Here in the Projects field, select the project that was assigned to billing, in the Dataset field, select the dataset created in the previous step, in the Service Account field, select the account created to have access to billing, then click Save to activate the Pricing Systems, as illustrated in the image below:

1. The Pricing System has been successfully activated! Now just wait for the bigquery to be populated with the billing data, this process takes between 4 to 6 hours.

Information that must be sent to pier cloud:

1. Credential in .json format

2. Client project id

3. billing account id (can be found in the billing overview in the format: 01D971-641F25-2A6D35)

4. Name of the BigQuery dataset of the project that receives the billing data (by default all_billing_data)

5. Location of bigquery

6. Project bucket name piercloud-billing