List all columns related to all tables within a dataset

PHOTO

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

# 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;

COPY

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

Save snippets that work from anywhere online with our extensions

Comments

BigQuery

@admariner

zisopoulos.com | Logflare | Cloudflare, Vercel & Elixir Logging List all tables and their creation time from a single dataset List metadata from selected tables with WHERE clause Obtain the size, number of rows and last modified time of all tables within our dataset List all columns related to all tables within a dataset Filter only timestamp columns used for partitioning Logflare - Bigquery Aggregation Formula

List all columns related to all tables within a dataset

Save snippets that work from anywhere online with our extensions

Comments

More like this

BigQuery

Browse more snippets >>

List all columns related to all tables within a dataset

Save snippets that work from anywhere online with our extensions

Comments

More like this

BigQuery

Browse more snippets >>

Embed code snippet