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.
Table of Contents