Custom Billing Format (FOCUS) in BigQuery

Mapping Key	Output Column	Type	Default	Status
`billedCost`	`billed_cost`	FLOAT64	NULL	Optional
`contractedCost`	`contracted_cost`	FLOAT64	NULL	Optional
`billingAccountId`	`billing_account_id`	STRING	NULL	Optional
`billingCurrency`	`billing_currency`	STRING	NULL	Optional
`originalBillingCurrency`	`original_billing_currency`	STRING	NULL	Optional
`billingPeriodEnd`	`billing_period_end`	DATETIME	NULL	Required
`billingPeriodStart`	`billing_period_start`	DATETIME	NULL	Required
`chargeCategory`	`charge_category`	STRING	NULL	Required
`chargeDescription`	`charge_description`	STRING	NULL	Optional
`chargeFrequency`	`charge_frequency`	STRING	NULL	Optional
`chargePeriodStart`	`charge_period_start`	TIMESTAMP	NULL	Optional
`chargePeriodEnd`	`charge_period_end`	TIMESTAMP	NULL	Optional
`commitmentDiscountCategory`	`commitment_discount_category`	STRING	NULL	Optional
`commitmentDiscountId`	`commitment_discount_id`	STRING	NULL	Optional
`commitmentDiscountType`	`commitment_discount_type`	STRING	NULL	Optional
`consumedQuantity`	`consumed_quantity`	FLOAT64	NULL	Optional
`consumedUnit`	`consumed_unit`	STRING	NULL	Optional
`effectiveCost`	`effective_cost`	FLOAT64	NULL	Optional
`invoiceIssuer`	`invoice_issuer`	STRING	NULL	Optional
`listCost`	`list_cost`	FLOAT64	NULL	Optional
`listUnitPrice`	`list_unit_price`	STRING	NULL	Optional
`pricingCategory`	`pricing_category`	STRING	NULL	Optional
`pricingQuantity`	`pricing_quantity`	FLOAT64	NULL	Optional
`pricingUnit`	`pricing_unit`	STRING	NULL	Optional
`provider`	`provider`	STRING	`"Custom BigQuery"`	Optional
`publisher`	`publisher`	STRING	NULL	Optional
`regionId`	`region_id`	STRING	NULL	Optional
`resourceId`	`resource_id`	STRING	NULL	Optional
`resourceName`	`resource_name`	STRING	NULL	Optional
`resourceType`	`resource_type`	STRING	NULL	Optional
`categoryFocus`	`category_focus`	STRING	NULL	Optional
`serviceName`	`service_name`	STRING	NULL	Optional
`skuId`	`sku_id`	STRING	NULL	Optional
`sku`	`sku`	STRING	NULL	Optional
`skuPriceId`	`sku_price_id`	STRING	NULL	Optional
`subAccountId`	`sub_account_id`	STRING	NULL	Optional
`tags`	`labels`	ARRAY<STRUCT<key STRING, value STRING>>	NULL	Optional

Get Started

Setup

Explore

Tag & Allocate

Reporting & Dashboards

Cost Changes

Teams

Planning

Technical Documentation

Glossary

Custom Billing Format (FOCUS) in BigQuery