List metadata from selected tables with WHERE clause

PHOTO EMBED

Mon Dec 20 2021 00:42:53 GMT+0000 (Coordinated Universal Time)

Saved by @admariner

# List metadata from selected tables with WHERE clause 
#standardSQL 
SELECT table_name, creation_time 
FROM `bigquery-public-data.ethereum_blockchain`.INFORMATION_SCHEMA.TABLES 
WHERE table_type = "BASE TABLE" 
AND table_name LIKE "%token%";
content_copyCOPY

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