most expensive queries bigquery

PHOTO EMBED

Wed Apr 06 2022 16:40:53 GMT+0000 (UTC)

Saved by @alvaroferrer #sql #aepd

SELECT Query, UserId, SUM(TotalCost) FROM `reby-cloud.bq_logs.bigquery_usage_datepart` 
WHERE DATE(Date) >= "2022-03-01" and DATE(Date) <= "2022-03-30" 
GROUP BY 1,2
ORDER BY 3 DESC
content_copyCOPY