Get the Last Modified date for all BigQuery tables in a BigQuery Project

user_2917381 0
Viewed 19407

I have several databases within a BigQuery project which are populated by various jobs engines and applications. I would like to maintain a dashboard of all of the Last Modified dates for every table within our project to monitor job failures.

enter image description here

Are there any command line or SQL commands which could provide this list of Last Modified dates?

google-bigquery google-cloud-platform sql
2 Answers

I've just queried stacked GA4 data using the following code:

FROM analytics_#########.__TABLES__
where table_id LIKE 'events_2%'

I have kept the 2 on the events to ensure my intraday tables do not pull through also.

user_195342930
Related