Google Cloud currently allow you to programmatically inspect your costs by exporting your project's billing information to a dedicated dataset configured in your project's BigQuery database.
Follow these steps provided by GCP official documentation in order to create a new dataset.
Follow these steps provided by GCP official documentation to export your billing information into an existing dataset in your BigQuery database. The exported billing information covers all your GCP projects that are under the same GCP billing account.
After the export has been configured, GCP will automatically create a new table in the provided dataset. The new table name should be like
gcp_billing_export_v1_011D4F_BEC512_83EA95 (for e.g).
Follow these steps provided by GCP official documentation to export new keys for your service account.
This service account should have the following permissions:
You can either create a custom role that includes these permissions (the preferred, more secured approach) and attach it to the service account, or you can attach the following GCP predefined roles to the service account:
BigQuery Job User
BigQuery Data Viewer
After the credentials have been created, download them as a JSON file.
If you wish to create the service account key via Terraform then our predefined template could be helpful.
- Under your Organization Settings, Select the Credentials tab
- Click Add Credential
- Select the
- Enter the BigQuery Table ID that you've created in the previous step.
Table ID should look like
PROJECT_ID- the GCP project name.
DATASET_NAME- the dataset name that you've created in the previous step.
TABLE_NAME- the table name that you've created in the previous step.
- Enter the
Service Account Key JSONthat you've created and downloaded in the previous step.
- Click Add
- Go to the Project Settings of the desired project.
- Select the Credentials tab.
- Check the appropriate cloud provider checkbox, and select the credential you created in the steps above.
- Click Save.
Updated 6 months ago