BigQuery Meta Tables
Meta tables are very useful when it comes to get bigquery table information programmatically.
In BigQuery, there are meta tables that we can use to retrieve information about the dataset and tables.
#standardSQL SELECT * FROM `homelike-bi-analysis.opportunity.__TABLES__`
You could get a list of all the tables and their
Alternatively, you could get some information through
SELECT * EXCEPT(is_typed) FROM `your_awesome_project.your_cool_dataset.INFORMATION_SCHEMA.TABLES`
These two queries return slightly different results.
Planted: by L Ma;
Generate a Column of Continuous Dates in BigQuery
Generate a table with a column of continuous dates
Lei Ma (2019). 'BigQuery Meta Tables', Datumorphism, 05 April. Available at: https://datumorphism.leima.is/til/data/bigquery-meta-tables/.