
Google Cloud Billing BillingExportQuery
CertifiedQuery GCP BigQuery Billing Export
Google Cloud Billing BillingExportQuery
Query GCP BigQuery Billing Export
Executes a parameterized cost aggregation query over standard or detailed GCP BigQuery billing export tables.
type: io.kestra.plugin.gcp.billing.BillingExportQueryExamples
Aggregate monthly costs by service description
id: gcp_monthly_cost
namespace: company.finops
tasks:
- id: cost_by_service
type: io.kestra.plugin.gcp.billing.BillingExportQuery
serviceAccount: "{{ secret('GCP_SA') }}"
exportTable: "my-project.billing.gcp_billing_export_v1_0123AB_4567CD_89EF01"
dateFrom: "{{ now() | dateAdd(-1, 'MONTHS') | date('yyyy-MM-dd') }}"
groupBy:
- "service.description"
fetchType: STORE
Installation
Our standard Docker images already include this plugin. If you use a -slim image or another setup, install it with the following command:
kestractl plugins get io.kestra.plugin:plugin-gcp --compatible-for $KESTRA_VERSION For kestractl, use your Kestra version with --compatible-for, or specify an exact plugin version.
For Kestra CLI, replace LATEST with a specific version or version range to pin the plugin version.
Properties
dateFrom *string
Query start date or timestamp
Inclusive start timestamp or date (e.g. 2026-09-01 or 2026-09-01T00: 00: 00Z). Will be parsed and validated as an ISO-8601 date or timestamp.
exportTable *string
BigQuery Billing Export table
Fully-qualified table name (e.g. my-project.dataset.gcp_billing_export_v1_XXXXXX or dataset.gcp_billing_export_v1_XXXXXX).
assets
Assets this task consumes as inputs or produces as outputs, for lineage tracking and the asset graph (Enterprise Edition). A flow declaring this property on a task is rejected in the open-source edition.
io.kestra.core.models.assets.AssetsDeclaration
IGNOREFAILWARNAsset failure behavior
Behavior applied to the task state when a declared asset fails to render, emit, or be persisted (e.g. a lock conflict): FAIL escalates it to FAILED, WARN (default) warns it if it would otherwise succeed, IGNORE leaves the state untouched.
Whether to auto-register assets referenced dynamically at runtime that are not statically declared in inputs or outputs.
The assets consumed as inputs.
io.kestra.core.models.assets.AssetIdentifier
1The assets produced as outputs.
io.kestra.plugin.ee.assets.Dataset
1150{}1150io.kestra.plugin.ee.assets.File
1150{}1150io.kestra.plugin.ee.assets.Table
1150{}1150io.kestra.plugin.ee.assets.VM
1150{}1150io.kestra.core.models.assets.External
1150{}1150io.kestra.core.models.assets.Custom
11501Custom asset type
{}1150dateTo string
Query end date or timestamp
Exclusive end timestamp or date (e.g. 2026-10-01 or 2026-10-01T00: 00: 00Z). Will be parsed and validated as an ISO-8601 date or timestamp.
destinationTable string
Destination BigQuery table
Optional destination table to write query results to.
fetchType string
FETCHSTOREFETCHFETCH_ONENONEResult handling mode
FETCH by default. Use STORE to save large result sets to Kestra internal storage.
filter string
Additional SQL filter expression
(Raw SQL fragment) Optional custom WHERE clause conditions to apply (e.g. project.id = 'my-project-id').
groupBy array
Fields to group by
(Raw SQL fragments or column expressions) List of columns or expressions to group costs by (e.g. ['service.description'], ['project.id', 'sku.description']). Dot-notated struct fields are automatically aliased (e.g. service.description AS service_description) to prevent duplicate column names in BigQuery.
impersonatedServiceAccount string
The GCP service account to impersonate
includeCredits booleanstring
trueInclude credits calculation
Whether to calculate net cost including promotions, discounts, and credits (default: true).
projectId string
The GCP project ID
scopes array
["https://www.googleapis.com/auth/cloud-platform"]The GCP scopes to be used
serviceAccount string
The GCP service account
When unset or rendered to an empty value, Application Default Credentials are used (e.g. GOOGLE_APPLICATION_CREDENTIALS or the runtime's attached identity).
workloadIdentityAudience string
Audience of the Workload Identity Federation provider
The full resource name of the workload identity pool provider, //iam.googleapis.com/projects/<number>/locations/global/workloadIdentityPools/<pool>/providers/<provider>.
Required with workloadIdentityToken, and must match the aud claim of the token.
workloadIdentityToken string
OIDC token for Workload Identity Federation
When set together with workloadIdentityAudience, the token is exchanged at Google STS for federated credentials and no service account key is needed: Google verifies it against the identity provider that issued it.
Use {{ oidcToken(audience='…') }} to have Kestra Enterprise mint one for the running execution.
Combine with impersonatedServiceAccount to act as a service account the pool may impersonate, and set projectId explicitly since no key file carries it.
Cannot be combined with serviceAccount.
Outputs
jobId string
The BigQuery job ID
row object
Single fetched result row when fetchType is FETCH_ONE
rows array
List of fetched result rows when fetchType is FETCH
size integer
The number of rows returned by the query
sql string
The generated SQL query executed against BigQuery
uri string
uriKestra internal storage URI when fetchType is STORE