Chapter 2. Creating a filtered Google Cloud integration

Procedure

1. From Red Hat Hybrid Cloud Console, click Settings Menu > Integrations.
2. On the Settings page, in the Cloud tab, click Add integration.
3. In the Add a cloud integration wizard, select Google Cloud as the cloud provider type and click Next.
4. Enter a name for your integration. Click Next.
5. In the Select application step, select Cost management and click Next.

In Google Cloud Console:

1. Click IAM & Admin Create a Project.
2. Enter a Project name and select your billing account.
3. Select Organization.
4. Enter the parent organization in Location.
5. Click Create.

In cost management:

6. On the Project page, enter your Project ID.
7. To configure Google Cloud to filter your data before it sends the data to Red Hat, select I wish to manually customize the data set sent to cost management.
8. Click Next.

In Google Cloud Console:

1. Go to Cloud Storage Buckets.
2. Click Create.
3. Name your bucket and enter any other information.
4. Click Create, then click Confirm.

In cost management:

5. On the Create cloud storage bucket page, enter your Cloud storage bucket name.

1. In Google Cloud Console, click IAM & Admin Roles.
2. Select the project that you created.
3. Click + Create role.
4. Enter a Title, Description and ID for the role.
5. Click + ADD PERMISSIONS.

6. In Enter property name or value, search for and select the following permissions for your custom role:

   • storage.objects.get
   • storage.objects.list
   • storage.buckets.get
7. Click ADD and then click CREATE.

In cost management:

8. In the Add a cloud integration wizard, on the Create IAM role page, click Next.

In Google Cloud Console:

1. Click IAM & Admin IAM.
2. Select the project that you created.
3. Click Grant Access.

4. Paste the following principal into the New principals field:

   billing-export@red-hat-cost-management.iam.gserviceaccount.com

   Copy to Clipboard Toggle word wrap
5. In the Assign roles section, enter the IAM role that you created.
6. Click SAVE.

Verification steps

1. Navigate to IAM & Admin IAM.
2. Verify that the new member is present with the correct role.

In Google Cloud Console:

1. Click BigQuery.
2. In the Explorer panel click the more options menu next to your project name and click Create dataset.
3. Name your dataset.
4. Click Create.

In Google Cloud Console:

1. Click Billing Billing export.
2. Click EDIT SETTINGS in the Detailed usage cost section.
3. Select the cost management Project and Billing export dataset that you created.
4. Click SAVE.

In cost management:

5. In the Add a cloud integration wizard, on the Billing export page, click Next.
6. On the Review details page, review the information about your integration and click Add.
7. Copy your source_uuid so that you can use it when you send API requests to cost management.

In Google Cloud Console:

1. Navigate to BigQuery
2. Select your dataset and the table that you created.
3. Click Query to test your custom query.
4. Save your query.
5. Export the query result as a CSV file.
6. Store the exported CSV in the bucket that you created.

1. In the following curl command, replace my_client_id and my_client_secret with your actual values:

1. Send the API request to cost management and indicate which CSV reports are ready to be processed. The following is an example request. In your request, update ENCRYPTED_TOKEN with your token, INTEGRATION_ID with your C.R.C integration ID, FILES_LIST with your list of CSV files, and YEAR and MONTH with the date of the files.