Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Labels applied to BigQuery not showing up in INFORMATION_SCHEMA

I have a few views in BigQuery whose queries can get pretty expensive, so I'm trying to apply labels to these views to be able to monitor their costs. I'm using a separate view to query cost-related information about these jobs. Here's a simplified version of the query:

SELECT creation_timetotal_bytes_billed, labels  
FROM `[project-id].region-[region].INFORMATION_SCHEMA.JOBS_BY_PROJECT`
WHERE job_type = 'QUERY'

I applied several labels last week (about 72 hours ago). They are still not appearing in the results of that query. I can see other labels like "sheets_connector" = "connected_sheets". I was expecting all the custom labels that I applied to the view to show up as well. What am I missing about how this works? Any help/guidance will be much appreciated!

1 5 3,434
5 REPLIES 5