Metricbeat GCP billing metricset is using BigQuery to collect billing data. When GCP billing project ID includes alphanumeric, it returns an errors:
bigquery Wait failed: googleapi: Error 400: Syntax error: Missing whitespace between literal and alias at [9:41], invalidQuery
Turned out the BigQuery query is missing quotes in Metricbeat code. For example, instead of FROM some-project-name-with-dashes.Dataset_Name.gcp_billing_export_v1_xxx, the syntax should be
FROM `some-project-name-with-dashes`.Dataset_Name.gcp_billing_export_v1_xxx
cc @endorama
Metricbeat GCP billing metricset is using BigQuery to collect billing data. When GCP billing project ID includes alphanumeric, it returns an errors:
Turned out the BigQuery query is missing quotes in Metricbeat code. For example, instead of
FROM some-project-name-with-dashes.Dataset_Name.gcp_billing_export_v1_xxx, the syntax should becc @endorama