Nicus Google BigQuery Integration
Use BigQuery’s billing export as a GCP cost source, or pull ITFM datasets.
BigQuery’s Cloud Billing export provides granular GCP cost data for ITFM. It also stores transformed datasets Nicus can access directly — useful at both ends of the ITFM data flow.
What This Integration Enables
- Aggregated and transformed financial and operational datasets
- Business activity and volume metrics stored in BigQuery
- Slot consumption and query cost data
- GCP Cloud Billing export data stored in BigQuery
- Customer, product, and service-level datasets for cost allocation
- Query activity data via INFORMATION_SCHEMA
Common Use Cases
- Accessing pre-modeled financial datasets for ITFM from BigQuery
- Using BigQuery billing export as a source of GCP cost data for ITFM
- Incorporating BigQuery Slot and query costs into ITFM models
- Business volume metrics from BigQuery used to drive cost allocation
Flexible Integration Options
Google BigQuery is a cloud-native, serverless data warehouse within Google Cloud Platform, designed for large-scale SQL-based analytics. Organizations use BigQuery to store, query, and model financial and operational datasets — and its billing data export capability makes it a central source of GCP cost and usage data. Compute costs are driven by Slot consumption (for reserved capacity) or on-demand query pricing.
Nicus uses data from Google BigQuery in two ways: as a source of aggregated and transformed financial and operational datasets, and as a source of BigQuery’s own Slot consumption and query costs for IT cost modeling.
FAQs
Does Nicus work with Google BigQuery?
Yes. Nicus uses data from BigQuery as a source of transformed financial and operational datasets, and incorporates BigQuery’s own Slot consumption and query costs into ITFM cost models.
What is the BigQuery billing export and why is it relevant for ITFM?
Google Cloud Billing can export detailed GCP cost and usage data to a BigQuery dataset. This export is a common way to access granular GCP cost data for incorporation into Nicus for ITFM and cost allocation.
What are BigQuery Slots and how do they relate to ITFM cost modeling?
BigQuery Slots are the compute capacity unit. Slot consumption and associated costs can be incorporated into Nicus to allocate BigQuery infrastructure costs to business units and services.