Extend the platform, empower your team.
Expand visibility to improve health and performance monitoring of your Snowflake
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.
Ensure that you have log monitoring enabled to get full log insight.
Steps to activate remote monitoring (version 1.255+):
WAREHOUSE CONSUMPTION: It is recommended to execute the queries on the smallest possible warehouse. The "Default" feature set of queries is executed every 12 hours. "Failure checks" and "Top N" queries are executed every 60 minutes.
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>;
Below is a complete list of the feature sets provided in this version. To ensure a good fit for your needs, individual metrics can be activated and deactivated by your administrator during configuration.
Route traffic, monitor cloud environments, monitor remote technologies with extensions and run synthetic monitors.
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.
Changes in this release