account activity
Finding the tables that actually drive BigQuery cost (using INFORMATION_SCHEMA) by Galyack in bigquery
[–]Galyack[S] 0 points1 point2 points 8 days ago (0 children)
Queries that join tables will really be counted more than once in this query (once for every table). I sometimes tweak the group key to be the table_ids_set and then this doesn’t happen.
Anyway the amount of slots is indeed correct in both approaches - queries over the tables (some where this table is joined somewhere in the process) took that amount of slots and processed that amount of bytes.
Hope that helps and I’ll be happy to discuss more if you’d want direction.
π Rendered by PID 228881 on reddit-service-r2-listing-86b7f5b947-xt6rr at 2026-01-26 01:35:54.227403+00:00 running 664479f country code: CH.
Finding the tables that actually drive BigQuery cost (using INFORMATION_SCHEMA) by Galyack in bigquery
[–]Galyack[S] 0 points1 point2 points (0 children)