List all tables and their creation time from a single dataset

PHOTO EMBED

Mon Dec 20 2021 00:42:19 GMT+0000 (UTC)

Saved by @admariner

# List all tables and their creation time from a single dataset
#standardSQL 
SELECT * 
FROM `bigquery-public-data.ethereum_blockchain`.INFORMATION_SCHEMA.TABLES;
content_copyCOPY

https://towardsdatascience.com/a-simple-way-to-query-table-metadata-in-google-bigquery-92dc7f1edec1