SnowflakeSnowflake
Expand visibility to improve health and performance monitoring of your Snowflake
Extension
- Product information
- Release notes
Overview
Snowflake monitoring is based on a remote monitoring approach implemented as a Dynatrace ActiveGate extension. The extension queries the Account Usage and Information Schema for key performance and health metrics, extending your visibility, and allowing DAVIS AI to provide anomaly detection and problem analysis.
Use cases
- Monitor current state of your Snowflake account
- Improve visibility into billing and credits
- Monitor storage consumption trends
- Monitor how much time each warehouse consumes
- Monitor availability of the Snowflake account.
Extension content
Content typeNumber of items included
generic relationship
1
screen layout
4
screen actions
4
metric metadata
16
document dashboard
1
dashboards
1
list screen layout
2
generic type
2
screen chart groups
10
screen entities lists
4
screen dql table
2
Feature sets
Below is a complete list of the feature sets provided in this version. To ensure a good fit for your needs, individual feature sets can be activated and deactivated by your administrator during configuration.
Feature setsNumber of metrics included
| Metric name | Metric key | Description | Unit |
|---|---|---|---|
| Snowflake availability | snowflake.account.availability | Whether Snowflake responds to queries or not | Percent |
| Warehouse compute credits used | snowflake.account.warehouse.credits.compute | Number of credits used for the warehouse. | Count |
| Warehouse cloud services credits used | snowflake.account.warehouse.credits.cloudServices | Number of credits used for cloud services for the warehouse. | Count |
| Warehouse credits used | snowflake.account.warehouse.credits.total | Number of credits billed for the warehouse. | Count |
| Account table storage bytes | snowflake.account.storage.table | Number of bytes of table storage used, including bytes for data currently in Time Travel. | Bytes |
| Account stage storage bytes | snowflake.account.storage.stage | Number of bytes of stage storage used by files in all internal stages (named, table, and user). | Bytes |
| Account fail-safe storage bytes | snowflake.account.storage.failsafe | Number of bytes of data in Fail-safe. | Bytes |
| Warehouse compilation time | snowflake.account.warehouse.time.compilation | Query compillation time per warehouse. | MilliSecond |
| Warehouse execution time | snowflake.account.warehouse.time.execution | Query execution time per warehouse. | MilliSecond |
| Warehouse elapsed time | snowflake.account.warehouse.time.elapsed | Query total elapsed time per warehouse. | MilliSecond |
| Warehouse queued provisioning time | snowflake.account.warehouse.time.queued.provisioning | Query queued provisioning time per warehouse. | MilliSecond |
| Warehouse queued overload time | snowflake.account.warehouse.time.queued.overload | Query queued overload time per warehouse. | MilliSecond |
| Warehouse blocked time | snowflake.account.warehouse.time.blocked | Query blocked time per warehouse. | MilliSecond |
| Account compute credits | snowflake.account.credits.compute | Number of credits used by warehouses and serverless compute resources. | Count |
| Account cloud services credits | snowflake.account.credits.cloudServices | Number of credits used for cloud services. | Count |
| Account total credits used | snowflake.account.credits.total | Total number of credits used by the account. | Count |
Full version history
To have more information on how to install the downloaded package, please follow the instructions on this page.
ReleaseDate
Full version history
New in this version:
- Added keyword key value pairs to extension
Full version history
New in this version
- dt.security_context is applied to
sql:snowflake_accountandsql:snowflake_warehouseentites. - Added screens for latest Dynatrace.
- Added New Dashboard for latest Dynatrace.
Improved in this version
- Improved layout of existing Unified Analysis screens.
Full version history
✨New in this version:
- Adds a new variable to control the timeout for collecting longest queries and failed queries
Full version history
- Adds two (2) fields to enable modification of the interval for account/warehouse queries and longest/failed queries
Full version history
v2.0.0
Breaking changes: monitoring configurations will have to be recreated to upgrade to this version.
Features:
- Availability metric
snowflake.account.availabilitythat gets reported every minute and does not use a warehouse, meaning that it does not consume credits and allows warehouse to split.
Improvements:
- Feature sets were renamed to better represent underlying technology.
- Account entity can be detected from Logs in addition to being detected based on Metrics.
Bug fixes:
statusattribute for Failed Queries and Longest Queries was renamed toexecution_statusto avoid conflict with built-in Dynatrace logsstatusproperty.
Full version history
The extension has been reworked to better reflect the existing Snowflake monitoring requirements. Account level metrics from ACCOUNT_USAGE schema are collected every 12 hours. Additionally, failed queries and top slowest queries are monitored every hour, if the corresponding feature sets are enabled.
Full version history
- Updated dashboard to follow standardized look and feel
Full version history
Changes in this release
- Metric fetching frequency reduced to once per 30 min.
Full version history
Initial release
