List all columns related to all tables within a dataset

PHOTO EMBED

Mon Dec 20 2021 00:45:14 GMT+0000 (UTC)

Saved by @admariner

# List all columns related to all tables within a dataset 
SELECT table_name, column_name, is_nullable, data_type, is_partitioning_column 
FROM `bigquery-public-data.ethereum_blockchain`.INFORMATION_SCHEMA.COLUMNS;
content_copyCOPY

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