Opinie (Examining Billing data with Big Query)

Robert J. · Sprawdzono ponad 8 lat temu

Phil B. · Sprawdzono ponad 8 lat temu

Kiran D. · Sprawdzono ponad 8 lat temu

Tim T. · Sprawdzono ponad 8 lat temu

Roberto B. · Sprawdzono ponad 8 lat temu

Anirudh Y. · Sprawdzono ponad 8 lat temu

Keith C. · Sprawdzono ponad 8 lat temu

Travis S. · Sprawdzono ponad 8 lat temu

Askar K. · Sprawdzono ponad 8 lat temu

Vlad I. · Sprawdzono ponad 8 lat temu

Naseem U. · Sprawdzono ponad 8 lat temu

Dariusz G. · Sprawdzono ponad 8 lat temu

Hiroaki S. · Sprawdzono ponad 8 lat temu

Yifei M. · Sprawdzono ponad 8 lat temu

did not work

cyril w. · Sprawdzono ponad 8 lat temu

Ernesto R. · Sprawdzono ponad 8 lat temu

Enmanuel D. · Sprawdzono ponad 8 lat temu

Jonathan P. · Sprawdzono ponad 8 lat temu

Edmar C. · Sprawdzono ponad 8 lat temu

Amit S. · Sprawdzono ponad 8 lat temu

Jonathan G. · Sprawdzono ponad 8 lat temu

Jose V. · Sprawdzono ponad 8 lat temu

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. · Sprawdzono ponad 8 lat temu

Leon J. · Sprawdzono ponad 8 lat temu

Cam C. · Sprawdzono ponad 8 lat temu