CODEWITHSUNDEEP
google-bigquery
georgeaueb
georgeaueb

Reputation: 51

Big Query: How to extract each tables creation time for a data set?

For one of my datasets, I am having a new table created at different a time every day.

Is there a way to extract / query these creation times for all tables?

Upvotes: 3

Views: 5259

Answers (1)

shollyman
shollyman

Reputation: 4384

This is available as the creationTime field in the tables.get API call.

Purely as an undocumented implementation detail of table wildcards, if you want to quickly fetch this via query you can query the __TABLES__ metatable that exists in a dataset:

SELECT table_id, creation_time FROM <dataset>.__TABLES__

Upvotes: 6

Related Questions