The CloudQuery GCP Billing source plugin reads detailed billing exports from BigQuery and loads them into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v1.0.0
Type
Source
Platforms
Date Published
Loading plugin tables
CloudQuery's use of cookies
We use tracking cookies to understand how you use the product and help us improve it. Your consent is required before we can enable these cookies. You can opt out via the link in the footer.
The gcpbilling_detailed_usage table shows data for Gcpbilling Detailed Usage.
This table supports incremental syncing. Read more about incremental syncing here.
bigquery.jobs.createbigquery.tables.listbigquery.tables.getbigquery.tables.getData| Name | Type |
|---|---|
| adjustment_info_id | utf8 |
| billing_account_id | utf8 |
| cost_type | utf8 |
| currency | utf8 |
| invoice_month | utf8 |
| labels_hash | utf8 |
| location_region | utf8 |
| location_zone | utf8 |
| price_tier_start_amount | float64 |
| project_id | utf8 |
| resource_global_name | utf8 |
| resource_name | utf8 |
| service_id | utf8 |
| sku_id | utf8 |
| subscription_instance_id | utf8 |
| system_labels_hash | utf8 |
| tags_hash | utf8 |
| transaction_type | utf8 |
| usage_end_time | timestamp[us, tz=UTC] |
| usage_start_time | timestamp[us, tz=UTC] |
| Name | Type |
|---|---|
| adjustment_info_description | utf8 |
| adjustment_info_id | utf8 |
| adjustment_info_mode | utf8 |
| adjustment_info_type | utf8 |
| billing_account_id | utf8 |
| consumption_model_applied_subscription_instance_id | utf8 |
| consumption_model_description | utf8 |
| consumption_model_id | utf8 |
| cost | float64 |
| cost_at_effective_price_default | float64 |
| cost_at_list | float64 |
| cost_at_list_consumption_model | float64 |
| cost_type | utf8 |
| _cq_id | uuid |
| _cq_parent_id | uuid |
| credits | json |
| credits_total | float64 |
| currency | utf8 |
| currency_conversion_rate | float64 |
| export_time | timestamp[us, tz=UTC] |
| invoice_month | utf8 |
| invoice_publisher_type | utf8 |
| labels | json |
| labels_hash | utf8 |
| location_country | utf8 |
| location_location | utf8 |
| location_region | utf8 |
| location_zone | utf8 |
| price_effective_price | float64 |
| price_effective_price_default | float64 |
| price_list_price | float64 |
| price_list_price_consumption_model | float64 |
| price_pricing_unit_quantity | float64 |
| price_tier_start_amount | float64 |
| price_unit | utf8 |
| project_ancestors | json |
| project_ancestry_numbers | utf8 |
| project_id | utf8 |
| project_labels | json |
| project_name | utf8 |
| project_number | utf8 |
| resource_global_name | utf8 |
| resource_name | utf8 |
| seller_name | utf8 |
| service_description | utf8 |
| service_id | utf8 |
| sku_description | utf8 |
| sku_id | utf8 |
| subscription_instance_id | utf8 |
| system_labels | json |
| system_labels_hash | utf8 |
| tags | json |
| tags_hash | utf8 |
| transaction_type | utf8 |
| usage_amount | float64 |
| usage_amount_in_pricing_units | float64 |
| usage_end_time | timestamp[us, tz=UTC] |
| usage_pricing_unit | utf8 |
| usage_start_time | timestamp[us, tz=UTC] |
| usage_unit | utf8 |