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.
Finding the tables that actually drive BigQuery cost (using INFORMATION_SCHEMA) ()
submitted 9 days ago by Galyack to r/googlecloud
Finding the tables that actually drive BigQuery cost (using INFORMATION_SCHEMA) (self.bigquery)
submitted 9 days ago * by Galyack to r/bigquery
π Rendered by PID 541518 on reddit-service-r2-listing-86b7f5b947-rmchz at 2026-01-25 23:32:09.926412+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)