In order to be able to get costs for jobs in a particular table, you can use BigQuery Audit Logs . You can create a BigQuery logging sink and then, you can query the logs table to get cost breakdowns.

Attached links to the official examples, by GCP.