We're a long time users of the Google BigQuery INFORMATION_SCHEMA.TABLE_STORAGE view, never had problem using it in our automated data processes. But a couple of days ago even the simpliest SELECT statements (like select * from my-project-name.region-eu.INFORMATION_SCHEMA.TABLE_STORAGE) to this view started to return following error:
INFORMATION_SCHEMA.TABLE_STORAGE hasn't been enabled for project my-project-name. Consider using one of the following SQL statements to enable data collection: ALTER PROJECT
my-project-nameSET OPTIONS (region-eu.enable_info_schema_storage= TRUE) Or to enable for the entire organization: ALTER ORGANIZATION SET OPTIONS (region-eu.enable_info_schema_storage= TRUE) After enabling, please allow around 1 day for the complete historical data to become available.
We tried to run that ALTER PROJECT ... command against our project, but it gave us another error:
One or more options are not supported
This error persists for region-eu, region-us, region-europe-west3, etc.
I wasn't able to find other mentions of the before mentioned errors, and kinda ran out of options what to try next to restore functionality.
No comments from google in my issue, but out monitoring queries work once again without errors.