Dynatrace Hub

Extend the platform,
empower your team.

Popular searches:

Snowflake

Snowflake

Expand visibility to improve health and performance monitoring of your Snowflake

Extension by Dynatrace

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

Get started

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

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 URL for connection (for example, https://zzyxxx-tc12345.snowflakecomputing.com)
Specify database name to connect to and warehouse which will execute the monitoring queries

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

Support

Built and supported by Dynatrace

Dynatrace support center

Subscribe to new releases

copy to clipboard

Extension content

Content typeNumber of items included

generic relationship

1

dashboards

1

metric metadata

15

generic type

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 metrics can be activated and deactivated by your administrator during configuration.

Feature setsNumber of metrics included

No matching metrics...

No matching metrics...

Metric name	Metric key	Description	Unit
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
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
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
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

Related to Snowflake

ActiveGate

Route traffic, monitor cloud environments, monitor remote technologies with extensions and 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

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.

Updated dashboard to follow standardized look and feel

Changes in this release

Metric fetching frequency reduced to once per 30 min.

Initial release

Discover recent additions to Dynatrace

Site Reliability Guardian

SRG: Automated change impact analysis for your deployment and release processes

DevSecOps Lifecycle Coverage with Snyk

Connect Snyk container scans and Dynatrace runtime insights for strong security.

Business Flow

Know your business result and see problematic process steps.

Salesforce Insights

Provides salesforce usage insights

Carbon Impact

Provides the information about site's carbon footprint

Analyze your data

Understand your data better with deep insights and clear visualizations.

Notebooks

Create powerful, data-driven documents for custom analytics and collaboration.

Dashboards

Transform complex data into clear visualizations with custom dashboards.

Automate your processes

Turn data and answers into actions, securely, and at scale.

Workflows

Automate tasks in your IT landscape, remediate problems, and visualize processes

Jira for Workflows

Jira Integration for managing Jira issues via Workflow actions

Slack for Workflows

Automate Slack messaging for security incidents, attacks, remediation, and more.

Secure your cloud application

See vulnerabilities and attacks in your environment.

Security overview

Get a comprehensive overview of the security of your applications.

Third-party vulnerabilities

Detect vulnerabilities in real time, with context and automated risk assessment.

Code-level vulnerabilities

Detect vulnerabilities in your code in real time.

Attacks

Get a real-time overview of all the attacks on your environment.

Are you looking for something different?We have hundred of apps, extensions, and other technologies to customize your environment

Leverage our newest innovations of Dynatrace Saas

Kick-start your app creation

Kick-start your app creation

Whether you’re a beginner or a pro, Dynatrace Developer has the tools and support you need to create incredible apps with minimal effort.

Go to Dynatrace Developer

Upgrading from Dynatrace Managed to SaaS

Upgrading from Dynatrace Managed to SaaS

Drive innovation, speed, and agility in your organization by seamlessly and securely upgrading.

Log Management and Analytics

Log Management and Analytics

Innovate faster and more efficiently with unified log management and log analytics for actionable insights and automation.