Snowflake warehouse usage can be obtained a few ways

1.) a view in the database.schema named snowflake.account_usage for example:

show views like '%WAREHOUSE_METERING_HISTORY%'

select * from snowflake.account_usage.warehouse_metering_history;

2.) a snowflake table function that is owned by the database snowflake

(note it appears this table function requires AccountAdmin role be the current role to use this functon)

select *
from table(information_schema.warehouse_metering_history(dateadd('days',-10,current_date())));