Snowflake

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.

Get started

Ensure that you have log monitoring enabled to get full log insight.

Activation

Steps to activate remote monitoring (version 1.255+):

Activate Extension in the Hub by going to:
Manage → Dynatrace Hub → Snowflake → Add to environment
Add new monitoring configuration
Specify full Snowflake host for connection (for example, zzyxxx-tc12345.snowflakecomputing.com)
Specify database name to connect to and warehouse which will execute the monitoring queries

WARNING: WAREHOUSE CONSUMPTION:: Data in the "Queries" feature set is retrieved every hour. Execution of the data retrieval queries requires warehouse to be active. Data in "default" feature set is retrieved every 720 minutes. With an exception for snowflake.account.availability metric that gets retrieved every minute and does not require a warehouse.

Permissions

There are two options to configure a user with proper permissions to query Snowflake for metrics.

Create a Dynatrace specific role and user to monitor Snowflake. In Snowflake, run the following to create a custom role with access to the ACCOUNT_USAGE schema.

This extension monitors SNOWFLAKE database, INFORMATION_SCHEMA, and ACCOUNT_USAGE schema. The SNOWFLAKE database is only viewable by users in the ACCOUNTADMIN role or any role granted by the ACCOUNTADMIN.
```
use role ACCOUNTADMIN;
grant imported privileges on database snowflake to role SYSADMIN;

use role SYSADMIN;
```

Alternatively, create a special DYNATRACE role with access to ACCOUNT_USAGE schema and INFORMATION_SCHEMA.

create role DYNATRACE;
grant imported privileges on database SNOWFLAKE to role DYNATRACE;

-- Create a user, skip this step if you are using an existing user.
create user DYNATRACE_USER;
LOGIN_NAME = DYNATRACE_USER;
password = '<PASSWORD>';
default_warehouse = <WAREHOUSE>;
default_role = DYNATRACE;
default_namespace = SNOWFLAKE.ACCOUNT_USAGE;

-- Grant the monitor role to the user.
grant role DYNATRACE to user <USER>;

Details

Listing longest running queries

Example DQL query to list longest running queries:

Note: "Queries" feature set must be enabled.

fetch logs
| filter matchesValue(dt.extension.name, "com.dynatrace.extension.sql-snowflake")
| filter matchesValue(event.group, "longest_queries")
| sort asDouble(execution_status) desc

Listing failed queries

Example DQL query to list failed queries:

Note: "Queries" feature set must be enabled.

fetch logs
| filter matchesValue(dt.extension.name, "com.dynatrace.extension.sql-snowflake")
| filter matchesValue(event.group, "failed_queries")
| sort timestamp desc

Provided by

Dynatrace

Support

By Dynatrace

Dynatrace support center

Subscribe to new releases

Copy to clipboard

Extension content

Content typeNumber of items included

generic relationship

metric metadata

dashboards

generic type

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

Related to Snowflake

ActiveGate

Route traffic, monitor clouds and remote technologies & run Synthetic monitors

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

v2.0.0

Breaking changes: monitoring configurations will have to be recreated to upgrade to this version.

Features:

Availability metric snowflake.account.availability that 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:

status attribute for Failed Queries and Longest Queries was renamed to execution_status to avoid conflict with built-in Dynatrace logs status property.

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.