Lab Name: Analyzing Billing Data with BigQuery
Use commands from here:
//////////////////////////////////////////////////////////////////////////
curl -LO raw.githubusercontent.com/QUICK-GCP-LAB/2-Minutes-Labs-Solutions/main/Analyzing%20Billing%20Data%20with%20BigQuery/gsp621.sh
sudo chmod +x gsp621.sh
./gsp621.sh
Link : https://console.cloud.google.com/proj...
SELECT CONCAT(service.description, ' : ',sku.description) as Line_Item FROM `billing_dataset.enterprise_billing` GROUP BY 1
SELECT CONCAT(service.description, ' : ',sku.description) as Line_Item, Count(*) as NUM FROM `billing_dataset.enterprise_billing` GROUP BY CONCAT(service.description, ' : ',sku.description)
//////////////////////////////////////////////////////////////////////////////
#arcade2025
#googlecloud2025
#googlecloudarcade2025
#HelloDev
#googlecloud2025
#qwiklabs
#thearcadechallenge
#googlecloudarcade