We are currently not doing a good job of tracking our Snowflake credit usage. We should create some data models here to give us more visibility into costs.
Most of the relevant information will be in the SNOWFLAKE.ORGANIZATION_USAGE schema. Some views (non-exhaustive) that track credit usage are:
AUTOMATIC_CLUSTERING_HISTORY
DATA_TRANSFER_HISTORY
DATABASE_STORAGE_USAGE_HISTORY
MATERIALIZED_VIEW_REFRESH_HISTORY
METERING_DAILY_HISTORY
PIPE_USAGE_HISTORY
STAGE_STORAGE_USAGE_HISTORY
STORAGE_DAILY_HISTORY
WAREHOUSE_METERING_HISTORY
There are also a couple of views that would be helpful if we could use them, but do not work when Snowflake is purchased through a reseller:
We are currently not doing a good job of tracking our Snowflake credit usage. We should create some data models here to give us more visibility into costs.
Most of the relevant information will be in the
SNOWFLAKE.ORGANIZATION_USAGEschema. Some views (non-exhaustive) that track credit usage are:AUTOMATIC_CLUSTERING_HISTORYDATA_TRANSFER_HISTORYDATABASE_STORAGE_USAGE_HISTORYMATERIALIZED_VIEW_REFRESH_HISTORYMETERING_DAILY_HISTORYPIPE_USAGE_HISTORYSTAGE_STORAGE_USAGE_HISTORYSTORAGE_DAILY_HISTORYWAREHOUSE_METERING_HISTORYThere are also a couple of views that would be helpful if we could use them, but do not work when Snowflake is purchased through a reseller:
USAGE_IN_CURRENCY_DAILYREMAINING_BALANCE_DAILY