File Export
When enabling GCP billing integration, select a type of file export for your Google Service account added to Cloudaware in order to avoid duplication of the billing data. Note that BigQuery is more preferable.
1. Log in to your Google console. Click Billing on the left.
2. Go to Billing export and select File export to set up a bucket for storing the billing reports. Select .csv format.
3. Go to Storage → Browser and click the bucket you selected before. Billing reports will be available in the section 'Objects' within 24 hours since the reporting was enabled.
4. Go to the tab 'Permissions'. Ensure the service account assigned to the appropriate project has the role Storage Object Viewer for Cloudaware to have getObject access for reading billing reports.
5. Log in to your Cloudaware account. Go to Admin.
6. Select Google Project Billing and click +Add.
7. Select Storage and insert the required details. Click Save.
8. The green light in 'Status' means that the Google billing integration has been added successfully. If there is a red light, please contact support@cloudaware.com.
BigQuery Export (preferable)
Since BigQuery export type is being continuously updated by Google, we recommend this type for working with billing data in Cloudaware.
1. Log in to your Google console. Select Billing on the left.
2. Go to Billing export and select BigQuery Export to have BigQuery datasets enabled.
3. Go to Big Data → BigQuery. In the section 'Resources' select the GCP project the billing datasets are consolidated under.
4. Select the dataset 'Billing' and pick a table under question. Click Share Dataset.
5. Type the name of the service account the GCP project for billing is managed by. Click Add → BigQuery assign the role 'BigQuery Data Viewer'. Click Done.
6. Log in to your Cloudaware account. Go to Admin.
7. Select Google Project Billing and click +Add.
8. Select BigQuery and insert the required details. Click Save.
9. The green light in 'Status' means that Google billing integration has been added successfully. If there is a red light, please contact support@cloudaware.com.
