Examining Billing data with Big Query Reviews

Robert J. · Reviewed over 8 years ago

Phil B. · Reviewed over 8 years ago

Kiran D. · Reviewed over 8 years ago

Tim T. · Reviewed over 8 years ago

Roberto B. · Reviewed over 8 years ago

Anirudh Y. · Reviewed over 8 years ago

Keith C. · Reviewed over 8 years ago

Travis S. · Reviewed over 8 years ago

Askar K. · Reviewed over 8 years ago

Vlad I. · Reviewed over 8 years ago

Naseem U. · Reviewed over 8 years ago

Dariusz G. · Reviewed over 8 years ago

Hiroaki S. · Reviewed over 8 years ago

Yifei M. · Reviewed over 8 years ago

did not work

cyril w. · Reviewed over 8 years ago

Ernesto R. · Reviewed over 8 years ago

Enmanuel D. · Reviewed over 8 years ago

Jonathan P. · Reviewed over 8 years ago

Edmar C. · Reviewed over 8 years ago

Amit S. · Reviewed over 8 years ago

Jonathan G. · Reviewed over 8 years ago

Jose V. · Reviewed over 8 years ago

There is a problem with this query: > Step 5: What is the most frequently used product costing more than a dollar? > > Paste the following query: > > SELECT product, cost, COUNT(*) > FROM [cloud-training-prod-bucket:arch_infra.billing_data] > WHERE ([cloud-training-prod-bucket:arch_infra.billing_data.cost] > 1) > GROUP BY cost, product > LIMIT 200 This query is not very useful, as it groups together usages over a dollar that have the exact same cost. In other words, all of the usages that were exactly $1.62 are grouped together; not sure what that's telling us. Maybe it should be: SELECT product, SUM(cost) AS totalcost, COUNT(*) AS usages FROM [cloud-training-prod-bucket:arch_infra.billing_data] WHERE [cloud-training-prod-bucket:arch_infra.billing_data.cost] > 1 GROUP BY product ORDER BY usages DESC LIMIT 1 This query finds out the total cost for all usages over a dollar and counts them, returning the most-frequently used product as asked by the lab. Also, lab failed to mention that you need to switch to the correct project in the BigTable interface before being able to perform any of these queries.

Brett L. · Reviewed over 8 years ago

Leon J. · Reviewed over 8 years ago

Cam C. · Reviewed over 8 years ago