Google Cloud

Summary

When registering a GCP account in OpsNow, you can manage cloud costs and resource information at the project level. To view cost information, you need to input the BigQuery Table Name; otherwise, only resource data will be displayed for the project.

Step1: Create and export BigQuery Dataset

If you haven't exported billing data to BigQuery yet, create a BigQuery dataset. If you don't plan to use the Cloud Cost Management menus, this step may not be necessary.

1. Select the project to register on OpsNow and click on the BigQuery menu. Select the created project, then click on the kebab button on the right -> [Create dataset].

2. Enter a dataset ID and click [CREATE DATASET] to create the dataset.

3. Go to Billing -> Billing export on the console. Under the Detailed usage cost section, click [EDIT SETTINGS].

4. Select the project created in step 1, the target project for the dataset, and the target dataset ID, and click the [Save] button. Once the billing export setting is completed, the screen will be displayed as the below image.

Creating a BigQuery dataset can take a few minutes up to a maximum of 5 days.

Check if Cloud Billing export settings are required and if the export is complete. If so, proceed to the next steps.

Step2: Enable Essential APIs

Please activate the three essential APIs. Click the ENABLE button for each API by accessing the links below:

• Cloud Resource Manager API

• Stackdriver Monitoring API

• BigQuery API

Step3: Create Service Account

Go to IAM & Admin > Service Accounts on GCP Console.

1. Click [+ CREATE SERVICE ACCOUNT].

2. Enter a service account name in the Service account name field and click the [DONE] button.

   
3. Click the newly created service account email on the service account list and check the email of the service account.

4. Copy and save the information somewhere as you will need this email address to grant permission to the service account.

Step4: Enter permission information

Go to the Manage resources page and select projects to which you want to grant permission.

1. On the right wing expanded, click [ADD PRINCIPAL].

2. (a)Paste the email address you copied and saved in step 4 in the New principals field.

   
3. Grant permissions to service accounts. (b)Select Viewer for Project, Monitoring Viewer for Monitoring. Click the [Save] button.

Step5: Enter BigQuery permission information

1. Select a project to grant BigQuery permission and click the [ADD PRINCIPAL] button on the right. It is recommended to create a new project for management.

2. Enter BigQuery permission information by taking the steps below.

3. Paste the email address you copied and saved in step 4 in the New principals field.

4. Grant BigQuery Data Viewer permission to the member and click the [Save] button.

Step6: Enter BigQuery table information (optional)

To use cost-related menus, register the BigQuery table name of the project you wish to add, along with the project to which the BigQuery table belongs. If the BigQuery table is already registered in OpsNow, you can check cost data by registering only the project.

Go to BigQuery page on console.

1. Select the BigQuery table with Billing Export configured.

2. Copy the Table ID from the DETAILS tab and paste it into the OpsNow BigQuery Table Name input field.

   

Step7: Create service account key & select project

Go to IAM & Admin -> Service Accounts.

1. Select a service account for which you want to create a service account key. Click the kebab button under the Actions column and select [Manage keys].

   
2. Click [ADD KEY] -> [Create new key].

3. Select JSON for the Key type and click the [CREATE] button. The key is saved on your PC as the image below. Register the service account key on OpsNow.

4. Once all project IDs mapped to projects are displayed, click the checkbox in front of the project you want to add and enter a name of the project. Click the checkbox in front of Project ID in the table header to add all projects on the list.

Google Cloud Account Connection and Data Collection

After linking your Google Cloud account, it may take up to 48 hours for data collection to be fully completed.