Examining Billing data with Big Query Reviews

Robert J. · Reviewed neredeyse 9 yıl ago

Phil B. · Reviewed neredeyse 9 yıl ago

Kiran D. · Reviewed neredeyse 9 yıl ago

Tim T. · Reviewed neredeyse 9 yıl ago

Roberto B. · Reviewed neredeyse 9 yıl ago

Anirudh Y. · Reviewed neredeyse 9 yıl ago

Keith C. · Reviewed neredeyse 9 yıl ago

Travis S. · Reviewed neredeyse 9 yıl ago

Askar K. · Reviewed neredeyse 9 yıl ago

Vlad I. · Reviewed neredeyse 9 yıl ago

Naseem U. · Reviewed neredeyse 9 yıl ago

Dariusz G. · Reviewed neredeyse 9 yıl ago

Hiroaki S. · Reviewed neredeyse 9 yıl ago

Yifei M. · Reviewed neredeyse 9 yıl ago

did not work

cyril w. · Reviewed neredeyse 9 yıl ago

Ernesto R. · Reviewed neredeyse 9 yıl ago

Enmanuel D. · Reviewed neredeyse 9 yıl ago

Jonathan P. · Reviewed neredeyse 9 yıl ago

Edmar C. · Reviewed neredeyse 9 yıl ago

Amit S. · Reviewed neredeyse 9 yıl ago

Jonathan G. · Reviewed neredeyse 9 yıl ago

Jose V. · Reviewed neredeyse 9 yıl 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 neredeyse 9 yıl ago

Leon J. · Reviewed neredeyse 9 yıl ago

Cam C. · Reviewed neredeyse 9 yıl ago