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.

• 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.

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>;
  

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