'Documentation on __TABLES__ and __TABLES_SUMMARY__ and other double underscore metadata (bigquery)
I'm diving into metadata available on datasets and tables in BigQuery.
There is enough documentation on INFORMATION_SCHEMA
:
https://cloud.google.com/bigquery/docs/information-schema-intro
But I can't find any on __TABLES__
, __TABLES_SUMMARY__
.
Where can I find information on this?
Are there any other double underscore functions like that?
What I'm using until now:
select * from `<project>.<dataset>.__TABLES__`
select * from `<project>.<dataset>.__TABLES_SUMMARY__`
Solution 1:[1]
__TABLES__
and __TABLES_SUMMARY__
is officially removed from Google BigQuery documentation and is not further in use. It was replaced with INFORMATION_SCHEMA.TABLES on May 2021.
Henceforth, to get the metadata of the tables it is advised to use INFORMATION_SCHEMA.TABLES
.
For reference as you mentioned this documentation is followed.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | Sakshi Gatyan |