The tables.get API call, when used with STORAGE_STATS, does not process data from the tables themselves, but rather retrieves metadata about the tables. This means that it doesn't matter how large the table is—the amount of data processed for the API call doesn't change. This call fetches details about the storage usage of the table, which is a metadata operation and generally does not count against your data processing quota.
Therefore, using tables.get for 10,000 tables, regardless of their size, would not incur costs associated with data scanning, as it does not actually scan table data but accesses metadata. It's still a good idea to monitor overall API calls if you're concerned about potential impacts on your quota. For comprehensive understanding, you may also consult the BigQuery API Quotas and Limits page.
LinkedIn
Twitter
