bigquery-optimization-queries
bigquery-optimization-queries copied to clipboard
doitintl
Queries to assist with BigQuery cost and performance.
Hey, just stumbled upon this repository, very useful idea - however, when looking at the results of this query we see heavy duplications occuring. A query that was triggered 1,141...
When doing some aggregations to compute the amount of slots per unit of time (like in the queries: query_slots_per_second.sql & slots_by_second.sql), the slots per unit of time is assessed by...
When doing some aggregations to compute the amount of slots per unit of time (like in the queries: query_slots_per_second.sql & slots_by_second.sql), then the following filter should be added in the...
Many queries used in this repo are calculating the on-demand costs and billed bytes/MBs/GBs like in this example: ``` SUM(COALESCE(totalBilledBytes, 0)) AS totalBilledBytes, ROUND(SUM(COALESCE(totalBilledBytes, 0)) / 1000000, 2) AS totalMegabytesBilled,...
We encountered the problem that information requests do not reflect the reality and produce enormous numbers. There is already an issue created by other users https://github.com/doitintl/bigquery-optimization-queries/issues/12 This PR fixes the...
in the file mentioned in the title, line 51 is throwing an error reading: "Query error: Unrecognized name: cost at [51:3]" Changing it to "on_demand_cost" solves it.
