[ADAP-847] [Bug] references to deprecated __TABLES__ metadata table

[sambloom92]

Is this a new bug in dbt-bigquery?

• I believe this is a new bug in dbt-bigquery
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

I noticed when running dbt docs generate that the BigQuery adapter is querying project.dataset.__TABLES__ in order to build the catalog. This metadata table was deprecated in May 2021 and was replaced with INFORMATION_SCHEMA.TABLES documented here. I am unaware of any potential impacts this may have, but I think it would be prudent to update this before any impacts might arise.

Expected Behavior

I would expect the BigQuery adapter to have removed references to the __TABLES__ metadata table and replaced them with INFORMATION_SCHEMA.TABLES

Steps To Reproduce

A quick search of this repository reveals several uses of __TABLES__ but no uses of INFORMATION_SCHEMA.TABLES

Relevant log output

No response

Environment

- OS:
- Python:
- dbt-core:
- dbt-bigquery:

Additional Context

No response

[dbeatty10]

Thanks for raising this @sambloom92 🧠

#113 had been closed after going stale, but I just re-opened it.

#364 has a draft implementation. It needs some more work around figuring out how to handle row_count or size_bytes which are present in project.dataset.__TABLES__ but not in project.dataset.INFORMATION_SCHEMA.TABLES.

I'm going to close this issue as a duplicate of #113, but we'd love to have you subscribe and participate in that issue and the corresponding PR to the extent you are interested.