Filter only timestamp columns used for partitioning

PHOTO EMBED

Mon Dec 20 2021 00:45:35 GMT+0000 (Coordinated Universal Time)

Saved by @admariner

#standardSQL 
SELECT table_name, column_name, is_nullable, data_type, is_partitioning_column 
FROM `bigquery-public-data.ethereum_blockchain`.INFORMATION_SCHEMA.COLUMNS 
WHERE data_type = "TIMESTAMP" 
AND is_partitioning_column = "YES";
content_copyCOPY

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