Skip to technology filters Skip to main content
Dynatrace Hub

Extend the platform,
empower your team.

Popular searches:
Home hero bg
SnowflakeSnowflake
Snowflake

Snowflake

Expand visibility to improve health and performance monitoring of your Snowflake

Extension
Free trial
Dashboard overviewTop warehouses by consumed time
  • 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
Dynatrace
By Dynatrace
Dynatrace support center
Subscribe to new releases
Copy to clipboard

Extension content

Content typeNumber of items included
generic relationship
1
metric metadata
16
dashboards
1
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 feature sets can be activated and deactivated by your administrator during configuration.

Feature setsNumber of metrics included
Metric nameMetric keyDescriptionUnit
Snowflake availabilitysnowflake.account.availabilityWhether Snowflake responds to queries or notPercent
Warehouse compute credits usedsnowflake.account.warehouse.credits.computeNumber of credits used for the warehouse.Count
Warehouse cloud services credits usedsnowflake.account.warehouse.credits.cloudServicesNumber of credits used for cloud services for the warehouse.Count
Warehouse credits usedsnowflake.account.warehouse.credits.totalNumber of credits billed for the warehouse.Count
Account table storage bytessnowflake.account.storage.tableNumber of bytes of table storage used, including bytes for data currently in Time Travel.Bytes
Account stage storage bytessnowflake.account.storage.stageNumber of bytes of stage storage used by files in all internal stages (named, table, and user).Bytes
Account fail-safe storage bytessnowflake.account.storage.failsafeNumber of bytes of data in Fail-safe.Bytes
Warehouse compilation timesnowflake.account.warehouse.time.compilationQuery compillation time per warehouse.MilliSecond
Warehouse execution timesnowflake.account.warehouse.time.executionQuery execution time per warehouse.MilliSecond
Warehouse elapsed timesnowflake.account.warehouse.time.elapsedQuery total elapsed time per warehouse.MilliSecond
Warehouse queued provisioning timesnowflake.account.warehouse.time.queued.provisioningQuery queued provisioning time per warehouse.MilliSecond
Warehouse queued overload timesnowflake.account.warehouse.time.queued.overloadQuery queued overload time per warehouse.MilliSecond
Warehouse blocked timesnowflake.account.warehouse.time.blockedQuery blocked time per warehouse.MilliSecond
Account compute creditssnowflake.account.credits.computeNumber of credits used by warehouses and serverless compute resources.Count
Account cloud services creditssnowflake.account.credits.cloudServicesNumber of credits used for cloud services.Count
Account total credits usedsnowflake.account.credits.totalTotal number of credits used by the account.Count

Related to Snowflake

ActiveGate logo

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

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

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

Dynatrace Hub
Get data into DynatraceBuild your own app
All (774)Log Management and AnalyticsKubernetesAI and LLM ObservabilityInfrastructure ObservabilitySoftware DeliveryApplication ObservabilityApplication SecurityDigital ExperienceBusiness Analytics
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed
Partner FinderBecome a partnerDynatrace Developer

Discover recent additions to Dynatrace

Problems logo

Problems

Analyze abnormal system behavior and performance problems detected by Davis AI.

Logs logo

Logs

Explore all your logs without writing a single query.

Security Investigator logo

Security Investigator

Fast and precise forensics for security and logs on Grail data with DQL queries.

Business Flow logo

Business Flow

Track, analyze, and optimize your critical business processes.

Cost & Carbon Optimization logo

Cost & Carbon Optimization

Track, analyze, and optimize your IT carbon footprint and public cloud costs.

Davis Anomaly Detection logo

Davis Anomaly Detection

Detect anomalies in timeseries using the Davis AI

Analyze your data

Understand your data better with deep insights and clear visualizations.

Notebooks logo

Notebooks

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

Dashboards logo

Dashboards

Transform complex data into clear visualizations with custom dashboards.

Automate your processes

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

Workflows logo

Workflows

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

Jira logo

Jira

Create, query, comment, transition, and resolve Jira tickets within workflows.

Slack logo

Slack

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

Secure your cloud application

See vulnerabilities and attacks in your environment.

Security Overview logo

Security Overview

Get a comprehensive overview of the security of your applications.

Code-Level Vulnerabilities logo

Code-Level Vulnerabilities

Detect vulnerabilities in your code in real time.

Threats & Exploits logo

Threats & Exploits

Understand, triage, and investigate application security findings and alerts.

Are you looking for something different?

We have hundreds 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.
Learn More
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.
Learn more