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.