The Snowflake ACCOUNT_USAGE schema has a lots of views, but I can’t find a view that shows warehouse_name and warehouse_size over time.

I’ve checked SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_EVENTS_HISTORY, SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_LOAD_HISTORY and SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY but I don’t think the warehouse size at a specific time can be inferred from there.

The SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY contains the warehouse_name and warehouse_size but then you really need to scan the whole QUERY_HISTORY to get the warehouse_name to warehouse_size mapping and even the mapping is not perfect since you only have datapoints if there was actually a query for that warehouse.

Is there any better way to obtain the warehouse_size for a given warehouse_name at a given point in time?