Snowflake metrics
Many of the collected metrics from Snowflake entities are displayed as widgets in SolarWinds Observability explorers; additional metrics may be collected and available in the Metrics Explorer. You can also create an alert for when an entity's metric value moves out of a specific range. See Entities in SolarWinds Observability SaaS for information about entity types in SolarWinds Observability SaaS.
The following table lists snowflake. in the search box.
| Metric | Units | Description |
|---|---|---|
snowflake.database.bytes_scanned.avg
|
Bytes (By) |
Average bytes scanned in a database over the last 24-hour period. |
snowflake.database.query.count
|
{queries} | Query Counts. Total query count for the database over the last 24-hour period. |
snowflake.query.blocked
|
{queries} | Blocked query count for the warehouse over the last 24-hour period. |
snowflake.query.bytes_deleted.avg
|
Bytes (By) | Query Bytes. Average bytes deleted in the database over the last 24-hour period. |
snowflake.query.bytes_written.avg
|
Bytes (By) | Query Bytes. Average bytes written by the database over the last 24-hour period. |
snowflake.query.compilation_time.avg
|
Seconds (s) | Query Times. Average time taken to compile a query over the last 24-hour period. |
snowflake.query.executed
|
{queries} | Executed query count for the warehouse over the last 24-hour period. |
snowflake.query.execution_time.avg
|
Seconds (s) | Query Times. Average time spent executing queries in the database over the last 24-hour period. |
snowflake.query.queued_overload
|
{queries} | Overloaded query count for the warehouse over the last 24-hour period. |
snowflake.query.queued_provision
|
{queries} | Number of compute resources queued for provisioning over the last 24-hour period. |
snowflake.queued_overload_time.avg
|
Seconds (s) | Queued Times. Average time spent in the warehouse queue due to the warehouse being overloaded over the last 24-hour period. |
snowflake.queued_provisioning_time.avg
|
Seconds (s) | Queued Times. Average time spent in the warehouse queue waiting for resources to provision over the last 24-hour period. |
snowflake.queued_repair_time.avg
|
Seconds (s) | Queued Times. Average time spent in warehouse queue waiting for compute resources to be repaired over the last 24-hour period. |
snowflake.storage.stage_bytes.total
|
Bytes (By) | Storage Bytes. Number of bytes of stage storage used by files in all internal stages (named, table, user). |
snowflake.storage.storage_bytes.total
|
Bytes (By) | Storage Bytes. Number of bytes of table storage used, including bytes for data currently in Time Travel. |
snowflake.total_elapsed_time.avg
|
Seconds (s) | Total Elapsed Time. Average elapsed time over the last 24-hour period. |
Optional metrics
| Metric | Units | Description |
|---|---|---|
snowflake.billing.cloud_service.total
|
{credits} |
Reported total credits used in the cloud service over the last 24-hour period. |
snowflake.billing.total_credit.total
|
{credits} | Used Credits. Reported total credits used across the account over the last 24-hour period. |
snowflake.billing.virtual_warehouse.total
|
{credits} | Reported total credits used by the virtual warehouse service over the last 24-hour period. |
snowflake.billing.warehouse.cloud_service.total
|
{credits} | Credits used across the cloud service for the given warehouse over the last 24-hour period. |
snowflake.billing.warehouse.total_credit.total
|
{credits} | Total credits used associated with the given warehouse over the last 24-hour period. |
snowflake.billing.warehouse.virtual_warehouse.total
|
{credits} | Total credits used by the virtual warehouse service for the given warehouse over the last 24-hour period. |
snowflake.logins.total
|
{logins} | Total login attempts for account over the last 24-hour period. |
snowflake.pipe.credits_used.total
|
{credits} | Snow pipe credits total used over the last 24-hour period. |
snowflake.query.bytes_spilled.local.avg
|
Bytes (By) | Average bytes spilled (intermediate results do not fit in memory) by the local storage over the last 24-hour period. |
snowflake.query.bytes_spilled.remote.avg
|
Bytes (By) | Average bytes spilled (intermediate results do not fit in memory) by the remote storage over the last 24-hour period. |
snowflake.query.data_scanned_cache.avg
|
Percentage (%) | Average percentage of data scanned from cache over the last 24-hour period. |
snowflake.query.partitions_scanned.avg
|
{partitions} | Number of partitions scanned during the query so far over the last 24-hour period. |
snowflake.rows_deleted.avg
|
{rows} | Row Operations. Number of rows deleted from a table (or tables) over the last 24-hour period. |
snowflake.rows_inserted.avg
|
{rows} | Row Operations. Number of rows inserted into a table (or tables) over the last 24-hour period. |
snowflake.rows_produced.avg
|
{rows} | Row Operations. Average number of rows produced by the statement over the last 24-hour period. |
snowflake.rows_unloaded.avg
|
{rows} | Row Operations. Average number of rows unloaded during data export over the last 24-hour period. |
snowflake.rows_updated.avg
|
{rows} | Row Operations. Average number of rows updated in a table over the last 24-hour period. |
snowflake.session_id.count
|
{session ids} | Distinct session id's associated with the snowflake username over the last 24-hour period. |
snowflake.storage.failsafe_bytes.total
|
Bytes (By) | Number of bytes of data in Fail-safe. |