Google Cloud Platform (GCP) Billing metrics

Collect billing metrics from Google Cloud Platform (GCP) with Elastic Agent


Version	2.33.1 (View all)
Compatible Kibana version(s)	8.12.0 or higher
Supported Serverless project types What's this?	Security Observability
Subscription level What's this?	Basic

Metrics

The billing dataset collects Cloud Billing Reports information from Google Cloud BigQuery daily cost detail table. BigQuery is a fully-managed, serverless data warehouse. Cloud Billing export to BigQuery enables you to export detailed Google Cloud billing data (such as usage, cost estimates, and pricing data) automatically throughout the day to a BigQuery dataset that you specify. Then you can access your Cloud Billing data from BigQuery for detailed analysis.

Please see export cloud billing data to BigQuery for more details on how to export billing data.

In BigQuery dataset, detailed Google Cloud daily cost data is loaded into a data table named gcp_billing_export_v1_<BILLING_ACCOUNT_ID>. There is a defined schema for Google Cloud daily cost data that is exported to BigQuery. Please see daily cost detail data schema for more details.

For standard usage cost data, set the table pattern format to gcp_billing_export_v1. This table pattern is set as the default when no other is specified.

For detailed usage cost data, set the table pattern to gcp_billing_export_resource_v1. Detailed tables include the standard fields and additional fields, such as effective_price, enabling a more granular view of expenses.

Sample Event

An example event for billing looks as following:

{
    "@timestamp": "2017-10-12T08:05:34.853Z",
    "cloud": {
        "account": {
            "id": "01475F-5B1080-1137E7"
        },
        "project": {
            "id": "elastic-bi",
            "name": "elastic-containerlib-prod"
        },
        "provider": "gcp"
    },
    "event": {
        "dataset": "gcp.billing",
        "duration": 115000,
        "module": "gcp"
    },
    "gcp": {
        "billing": {
            "billing_account_id": "01475F-5B1080-1137E7",
            "cost_type": "regular",
            "invoice_month": "202106",
            "project_id": "containerlib-prod-12763",
            "project_name": "elastic-containerlib-prod",
            "total": 4717.170681,
            "sku_id": "0D56-2F80-52A5",
            "service_id": "6F81-5844-456A",
            "sku_description": "Network Inter Region Ingress from Jakarta to Americas",
            "service_description": "Compute Engine",
            "effective_price": 0.00292353,
            "tags": [
                {
                    "key": "stage",
                    "value": "prod"
                },
                {
                    "key": "size",
                    "value": "standard"
                }
            ]
        }
    },
    "metricset": {
        "name": "billing",
        "period": 10000
    },
    "service": {
        "type": "gcp"
    }
}

Exported fields

Exported fields

Field	Description	Type
@timestamp	Event timestamp.	date
cloud	Fields related to the cloud or infrastructure the events are coming from.	group
cloud.account.id	The cloud account or organization id used to identify different entities in a multi-tenant environment. Examples: AWS account id, Google Cloud ORG Id, or other unique identifier.	keyword
cloud.account.name	The cloud account name or alias used to identify different entities in a multi-tenant environment. Examples: AWS account name, Google Cloud ORG display name.	keyword
cloud.availability_zone	Availability zone in which this host, resource, or service is located.	keyword
cloud.image.id	Image ID for the cloud instance.	keyword
cloud.instance.id	Instance ID of the host machine.	keyword
cloud.instance.name	Instance name of the host machine.	keyword
cloud.machine.type	Machine type of the host machine.	keyword
cloud.project.id	Name of the project in Google Cloud.	keyword
cloud.provider	Name of the cloud provider. Example values are aws, azure, gcp, or digitalocean.	keyword
cloud.region	Region in which this host, resource, or service is located.	keyword
container.id	Unique container id.	keyword
container.image.name	Name of the image the container was built on.	keyword
container.labels	Image labels.	object
container.name	Container name.	keyword
data_stream.dataset	Data stream dataset.	constant_keyword
data_stream.namespace	Data stream namespace.	constant_keyword
data_stream.type	Data stream type.	constant_keyword
ecs.version	ECS version this event conforms to. `ecs.version` is a required field and must exist in all events. When querying across multiple indices -- which may conform to slightly different ECS versions -- this field lets integrations adjust to the schema version of the events.	keyword
error	These fields can represent errors of any kind. Use them for errors that happen while fetching events or in cases where the event itself contains an error.	group
error.message	Error message.	match_only_text
event.dataset	Event dataset	constant_keyword
event.module	Event module	constant_keyword
gcp.billing.billing_account_id	Project Billing Account ID.	keyword
gcp.billing.cost_type	Cost types include regular, tax, adjustment, and rounding_error.	keyword
gcp.billing.effective_price	The charged price for usage of the Google Cloud SKUs and SKU tiers. Reflects contract pricing if applicable, otherwise, it's the list price.	float
gcp.billing.invoice_month	Billing report month.	keyword
gcp.billing.project_id	Project ID of the billing report belongs to.	keyword
gcp.billing.project_name	Project Name of the billing report belongs to.	keyword
gcp.billing.service_description	The Google Cloud service that reported the Cloud Billing data.	keyword
gcp.billing.service_id	The ID of the service that the usage is associated with.	keyword
gcp.billing.sku_description	A description of the resource type used by the service. For example, a resource type for Cloud Storage is Standard Storage US.	keyword
gcp.billing.sku_id	The ID of the resource used by the service.	keyword
gcp.billing.tags.key		keyword
gcp.billing.tags.value		keyword
gcp.billing.total	Total billing amount.	float
host.architecture	Operating system architecture.	keyword
host.containerized	If the host is a container.	boolean
host.domain	Name of the domain of which the host is a member. For example, on Windows this could be the host's Active Directory domain or NetBIOS domain name. For Linux this could be the domain of the host's LDAP provider.	keyword
host.hostname	Hostname of the host. It normally contains what the `hostname` command returns on the host machine.	keyword
host.id	Unique host id. As hostname is not always unique, use values that are meaningful in your environment. Example: The current usage of `beat.name`.	keyword
host.ip	Host ip addresses.	ip
host.mac	Host mac addresses.	keyword
host.name	Name of the host. It can contain what `hostname` returns on Unix systems, the fully qualified domain name, or a name specified by the user. The sender decides which value to use.	keyword
host.os.build	OS build information.	keyword
host.os.codename	OS codename, if any.	keyword
host.os.family	OS family (such as redhat, debian, freebsd, windows).	keyword
host.os.kernel	Operating system kernel version as a raw string.	keyword
host.os.name	Operating system name, without the version.	keyword
host.os.name.text	Multi-field of `host.os.name`.	text
host.os.platform	Operating system platform (such centos, ubuntu, windows).	keyword
host.os.version	Operating system version as a raw string.	keyword
host.type	Type of host. For Cloud providers this can be the machine type like `t2.medium`. If vm, this could be the container, for example, or other information meaningful in your environment.	keyword
service.type	The type of the service data is collected from. The type can be used to group and correlate logs and metrics from one service type. Example: If logs or metrics are collected from Elasticsearch, `service.type` would be `elasticsearch`.	keyword

Changelog

Version	Details	Kibana version(s)
2.33.1	Enhancement View pull request Update Legacy metric visualization to new metric in GCP Billing overview dashboard.	8.12.0 or higher
2.33.0	Enhancement View pull request Enable time series data for metrics data streams. This dramatically reduces storage for metrics and is expected to progressively improve query performance. For more details, see https://www.elastic.co/guide/en/elasticsearch/reference/current/tsds.html.	8.12.0 or higher
2.32.1	Enhancement View pull request Add dimensions mappings and the metrics_fingerprint field across all metrics data streams.	8.12.0 or higher
2.32.0	Enhancement View pull request Add new billing data stream fields.	8.12.0 or higher
2.31.2	Bug fix View pull request Fix pipeline error parsing DNS logs with empty rdata field.	8.7.1 or higher
2.31.1	Enhancement View pull request Add Cloud Run docs and fix policy template name to allow adding Cloud Run logs to the policy.	8.7.1 or higher
2.31.0	Enhancement View pull request Allow users to retain otherwised discarded fields.	8.7.1 or higher
2.30.1	Bug fix View pull request Fix mappings of group fields	8.7.1 or higher
2.30.0	Enhancement View pull request Add tags.yml file so that integration's dashboards and saved searches are tagged with "Security Solution" and displayed in the Security Solution UI. Enhancement View pull request Upgrade package spec to 3.0.0. Bug fix View pull request Fix orphan dashboard references. Bug fix View pull request Add missing dashboard filters.	8.7.1 or higher
2.29.1	Bug fix View pull request Add null checks and ignore_missing checks to the rename processor	8.7.1 or higher
2.29.0	Bug fix View pull request Remove GCP CloudSQL deprecated, alpha or beta metrics and fix field types.	8.7.1 or higher
2.28.5	Enhancement View pull request Set metric type for GKE, Load Balancing, PubSub, Redis and Storage data streams.	8.7.1 or higher
2.28.4	Enhancement View pull request Migrate GCP Load Balancing HTTPS Overview dashboard to lens.	8.7.1 or higher
2.28.3	Enhancement View pull request Set metric type for Cloud Run, Compute, Dataproc and Firestore data streams.	8.7.1 or higher
2.28.2	Enhancement View pull request Migrate GCP Load Balancing TCP SSL Proxy Overview dashboard to lens.	8.7.1 or higher
2.28.1	Enhancement View pull request Set metric type for CloudSQL data streams.	8.7.1 or higher
2.28.0	Enhancement View pull request Migrate GCP Load Balancing L3 Overview dashboard to lens.	8.7.1 or higher
2.27.0	Enhancement View pull request Add GCP CloudSQL MySQL, SQL Server and PostgreSQL dashboards.	8.7.1 or higher
2.26.0	Bug fix View pull request Fix GCP loadbalancing_metrics fields prefix.	8.7.1 or higher
2.25.1	Bug fix View pull request Fix check on gcp.audit.authorization_info[].granted.	8.7.1 or higher
2.25.0	Enhancement View pull request Migrate GCP Billing input control to new control panel.	8.7.1 or higher
2.24.0	Enhancement View pull request Add GCP CloudSQL MySQL, Postgres, SQLServer data streams	8.7.1 or higher
2.23.0	Enhancement View pull request Convert security dashboards to lens.	8.7.1 or higher
2.22.1	Enhancement View pull request Change ownership in manifest.	8.6.0 or higher
2.22.0	Enhancement View pull request Ensure event.kind is correctly set for pipeline errors.	8.6.0 or higher
2.21.0	Enhancement View pull request Update package to ECS 8.8.0.	8.6.0 or higher
2.20.1	Bug fix View pull request Fix invalid TSDS metric type for persistence.rdb.bgsave_in_progress field	8.6.0 or higher
2.20.0	Enhancement View pull request Update package to ECS 8.7.0.	8.6.0 or higher
2.19.1	Enhancement View pull request Migrate compute dashboard to lens and add datastream filter.	8.6.0 or higher
2.19.0	Enhancement View pull request Add Cloud Run metrics datastream.	8.6.0 or higher
2.18.0	Enhancement View pull request Support `subscription_num_goroutines` and `subscription_max_outstanding_messages` for GCP PubSub input	8.6.0 or higher
2.17.2	Bug fix View pull request Fix IP Convert processor in Audit ingest pipeline.	8.6.0 or higher
2.17.1	Enhancement View pull request Added categories and/or subcategories.	8.6.0 or higher
2.17.0	Enhancement View pull request Add Audit Log Overview dashboard Enhancement View pull request Add GKE Overview dashboard Enhancement View pull request Add PubSub Overview dashboard Enhancement View pull request Add Storage Overview dashboard	8.6.0 or higher
2.16.2	Bug fix View pull request Add logic to handle scalar request.policy values on audit	8.5.0 or higher
2.16.1	Bug fix View pull request Replace missing input control panel with new-style control.	8.5.0 or higher
2.16.0	Enhancement View pull request Update package to ECS 8.6.0.	8.5.0 or higher
2.15.2	Enhancement View pull request Update documentation.	8.5.0 or higher
2.15.1	Enhancement View pull request Add GCP Compute pipeline test.	8.5.0 or higher
2.15.0	Enhancement View pull request Remove support for Kibana 7.17.x Enhancement View pull request Support multiple regions for metrics data streams	8.5.0 or higher
2.14.0	Enhancement View pull request Update package to ECS 8.5.0.	8.3.0 or higher
2.13.0	Enhancement View pull request Migrate dashboard by values	8.3.0 or higher
2.12.1	Bug fix View pull request Remove duplicate fields.	7.17.6 or higher 8.3.0 or higher
2.12.0	Enhancement View pull request Add GCP Redis	7.17.6 or higher 8.3.0 or higher
2.11.12	Bug fix View pull request Add GKE ingest pipeline.	7.17.6 or higher 8.3.0 or higher
2.11.11	Bug fix View pull request Fix type of dns.answers.ttl.	7.17.6 or higher 8.3.0 or higher
2.11.10	Enhancement View pull request Add ingest pipeline for dataproc. Enhancement View pull request Add GCP loadbalancing ingest pipeline Enhancement View pull request Add GCP PubSub ingest pipeline Enhancement View pull request Add GCP Storage ingest pipeline Enhancement View pull request Add GCP Firestore ingest pipeline Enhancement View pull request Add GCP Compute ingest pipeline	7.17.6 or higher 8.3.0 or higher
2.11.10-beta.6	Enhancement View pull request Add ingest pipeline for dataproc.	—
2.11.10-beta.5	Enhancement View pull request Add GCP loadbalancing ingest pipeline	—
2.11.10-beta.4	Enhancement View pull request Add GCP PubSub ingest pipeline	—
2.11.10-beta.3	Enhancement View pull request Add GCP Storage ingest pipeline	—
2.11.10-beta.2	Enhancement View pull request Add GCP Firestore ingest pipeline	—
2.11.10-beta.1	Enhancement View pull request Add GCP Compute ingest pipeline	—
2.11.9	Bug fix View pull request Fix GKE kubernetes.io indentation.	7.17.6 or higher 8.3.0 or higher
2.11.8	Enhancement View pull request Remove duplicate fields.	7.17.6 or higher 8.3.0 or higher
2.11.7	Enhancement View pull request Move Dataproc lightweight module config into integration	7.17.6 or higher 8.3.0 or higher
2.11.6	Enhancement View pull request Move LoadBalancing lightweight module config into integration	7.17.6 or higher 8.3.0 or higher
2.11.5	Enhancement View pull request Move Storage lightweight module config into integration	7.17.6 or higher 8.3.0 or higher
2.11.4	Enhancement View pull request Move PubSub lightweight module config into integration	7.17.6 or higher 8.3.0 or higher
2.11.3	Enhancement View pull request Move GKE lightweight module config into integration	7.17.6 or higher 8.3.0 or higher
2.11.2	Enhancement View pull request Move Firestore lightweight module config into integration	7.17.6 or higher 8.3.0 or higher
2.11.1	Enhancement View pull request Use ECS geo.location definition.	7.17.6 or higher 8.3.0 or higher
2.11.0	Enhancement View pull request Move Compute lightweight module config into integration	7.17.6 or higher 8.3.0 or higher
2.10.0	Enhancement View pull request Add GCP PubSub Data stream	7.17.6 or higher 8.3.0 or higher
2.9.0	Enhancement View pull request Add GCP Dataproc Data stream	7.17.6 or higher 8.3.0 or higher
2.8.0	Enhancement View pull request Add GCP GKE Data Stream	7.17.6 or higher 8.3.0 or higher
2.7.0	Enhancement View pull request Add GCP Storage Data Stream	7.17.6 or higher 8.3.0 or higher
2.6.0	Enhancement View pull request Add Load Balancing logs datastream	7.17.6 or higher 8.3.0 or higher
2.5.0	Enhancement View pull request Add GCP Load Balancing Metricset Bug fix View pull request Fix credentials_json escaping in loadbalancing_metrics Bug fix View pull request Update loadbalancing_metrics default period to 60s Bug fix View pull request Fix event.dataset for loadbalancing_metrics Enhancement View pull request Add loadbalancing_metrics distribution fields	7.17.6 or higher 8.3.0 or higher
2.4.0	Enhancement View pull request Update package to ECS 8.4.0	7.17.6 or higher 8.3.0 or higher
2.3.0	Enhancement View pull request Add additional parsing for DNS Public Zone Query Logs	7.17.6 or higher 8.3.0 or higher
2.2.1	Enhancement View pull request Fix Billing policy template title and default period for gcp.compute	7.17.6 or higher 8.3.0 or higher
2.2.0	Enhancement View pull request Remove fields duplicated in ECS fields	7.17.6 or higher 8.3.0 or higher
2.1.0	Enhancement View pull request restore compatibility with 7.17 release track	7.17.6 or higher 8.3.0 or higher
2.0.0	Breaking change View pull request Move configurations to support metrics. This change is breaking, as it moves some configuration from the top level variables to data stream variables. This change involves `project_id`, `credentials_file` and `credentials_json` variables that are moved from input level configuration to package level configuration (as those variables are reused across all inputs/data streams). Users with GCP integration enabled will need to input values for these variables again when upgrading the policies to this version. Enhancement View pull request Add GCP Billing Data Stream Enhancement View pull request Add GCP Compute Data Stream Enhancement View pull request Add GCP Firestore Data stream	8.3.0 or higher
1.10.0	Enhancement View pull request Update package to ECS 8.3.0.	7.17.0 or higher 8.0.0 or higher
1.9.2	Bug fix View pull request Fix GCP auditlog parsing issue on response status	7.17.0 or higher 8.0.0 or higher
1.9.1	Enhancement View pull request Update readme	7.17.0 or higher 8.0.0 or higher
1.9.0	Enhancement View pull request Preserve request and response in flattened fields.	7.17.0 or higher 8.0.0 or higher
1.8.0	Enhancement View pull request Add missing `cloud.provider` field.	7.17.0 or higher 8.0.0 or higher
1.7.0	Enhancement View pull request Add dashboards for firewall and vpc flow logs. Bug fix View pull request Add missing mappings for several `event.*` fields.	—
1.6.1	Enhancement View pull request Clarify the GCP privileges required by the Pub/Sub input.	7.16.3 or higher 8.0.0 or higher
1.6.0	Enhancement View pull request Update to ECS 8.2	—
1.5.1	Enhancement View pull request Add documentation for multi-fields	7.16.3 or higher 8.0.0 or higher
1.5.0	Enhancement View pull request Improve Google Cloud Platform docs.	7.16.3 or higher 8.0.0 or higher
1.4.2	Bug fix View pull request Remove emtpy values, names with only dots, and invalid client IPs.	7.16.3 or higher 8.0.0 or higher
1.4.1	Bug fix View pull request Fix quoting of the credentials_json value in policy templates.	7.16.3 or higher 8.0.0 or higher
1.4.0	Enhancement View pull request Add gcp.dns integration	—
1.3.1	Bug fix View pull request Add Ingest Pipeline script to map IANA Protocol Numbers	7.15.0 or higher 8.0.0 or higher
1.3.0	Enhancement View pull request Update to ECS 8.0	7.15.0 or higher 8.0.0 or higher
1.2.2	Bug fix View pull request Regenerate test files using the new GeoIP database	7.15.0 or higher 8.0.0 or higher
1.2.1	Bug fix View pull request Change test public IPs to the supported subset	—
1.2.0	Enhancement View pull request Add 8.0.0 version constraint	7.15.0 or higher 8.0.0 or higher
1.1.2	Enhancement View pull request Update Title and Description.	7.15.0 or higher
1.1.1	Bug fix View pull request Fix logic that checks for the 'forwarded' tag	—
1.1.0	Enhancement View pull request Update to ECS 1.12.0	7.15.0 or higher
1.0.0	Enhancement View pull request Move from experimental to GA Enhancement View pull request remove experimental from data_sets	—
0.3.3	Enhancement View pull request Convert to generated ECS fields	—
0.3.2	Enhancement View pull request update to ECS 1.11.0	—
0.3.1	Enhancement View pull request Escape special characters in docs	—
0.3.0	Enhancement View pull request Update integration description	—
0.2.0	Enhancement View pull request Set "event.module" and "event.dataset"	—
0.1.0	Enhancement View pull request update to ECS 1.10.0 and adding event.original options	—
0.0.2	Enhancement View pull request update to ECS 1.9.0	—
0.0.1	Enhancement View pull request initial release	—

On this page

Article navigation

Metrics

Sample Event

Exported fields

Changelog