Skip to technology filters Skip to main content
Dynatrace Hub

Extend the platform,
empower your team.

Popular searches:
Home hero bg
Snowflake for WorkflowsSnowflake for Workflows
Snowflake for Workflows

Snowflake for Workflows

Access, query, and store Snowflake data to analyze further within Dynatrace.

App
Free trialDocumentation
Add one of the two available actions: Query and process snowflake data from within the workflow or execute a query and store the results in Grail.Add the SQL statement to execute queries on Snowflake. Use the form fields to set relevant parameters.
  • Product information
  • Release notes

Overview

Unlock new use cases by integrating Snowflake data with data stored in Grail.

Enterprises are using diverse tools to address their business needs, resulting in separate data silos. Dynatrace's goal to provide complete visibility and get contextual insights doesn't stop at the edge of Grail and, therefore, natively integrates with multiple Enterprise tools.

Snowflake for Workflows is a fast, flexible, and secure way to query and process Snowflake data within Dynatrace. It adds two new actions to Workflows, which allows you to execute SQL statements and process the result sent in the response. You can use the result set within the workflow, enrich already available data, or persist it in Dynatrace as a new Business event.

Use cases

Access relational data from Snowflake to ...

  • contextualize data: enrich data stored in Grail with additional context from Snowflake
  • utilize Davis Analyzers on Snowflake data: pull in data to perform complex analysis by leveraging Dynatrace's anomaly detection and forecasting capabilities
  • address Data Observability use cases based on metadata stored in Snowflake
  • or gather new business analytics insights by joining observability data with data natively stored in Snowflake. This means your data stays always fresh - natively stored in Snowflake.

Get started

  • Install the connector
  • Set up and authorize the connection to Snowflake
  • Either create a new workflow or add one of the Snowflake actions to an existing one
  • Utilize the data to perform look-ups, reuse the data in adjacent workflow steps, or store it in Grail
  • Run the workflow on demand, periodically, or even triggered by specific events
  • Use Notebooks or Dashboards to query Snowflake data stored as Business events
Dynatrace
Documentation
By Dynatrace
Dynatrace support center
Subscribe to new releases
Copy to clipboard

Related to Snowflake for Workflows

Grail logo

Grail

Dynatrace's data lakehouse providing unified storage for any type of data.

Snowflake logo

Snowflake

Expand visibility to improve health and performance monitoring of your Snowflake.

Workflows logo

Workflows

Automate tasks in your IT landscape and move towards autonomous operations.

Full version history

ReleaseDate

Full version history

Minor Changes

  • Adding PAT as an authentication method for Snowflake

Patch Changes

  • Updating dependencies

Full version history

Patch Changes

  • Replaced "moment" library usage with "date-fns"
  • Fixing the issue of fractions not being properly represented - they were incorrectly scaled to higher values.

Full version history

1.1.0

Minor Changes

Streaming the Snowflake response per data record to avoid issues with memory when loading whole partitions.

Patch Changes

Updating dependencies

Full version history

1.0.0

The first official version of the Snowflake Connector.

Features

  • Snowflake for Workflows supports two types of actions:
    • execute-statement that just executes the SQL statement on Snowflake and returns the first partition of data as the result so other workflow actions can use it
    • store-statement-result that executes SQL statement on Snowflake and ingests all data partitions into Grail as either BizEvents or lookup tables.

Minor Changes

  • Replaced allowed users feature by access control settings.
  • Migrating actions to stateful actions, allowing them to pass the 2-min execution limit.
  • Added support for overwriting event.type field of BizEvents
  • Introduce a new, streamlined connection management experience with a modernized interface. This update makes adding and editing connections directly within workflows easier and provides connection control and convenience in one place.
  • Added lookup tables as an option of Grail storage type

Patch Changes

  • Disabling validations on expressions in the lookup file path
  • Fixing the error with the missing permission to create Lookup Tables. Improved logging in case of an error.
  • Fixed race conditions in lookup table creation if the request failed early during streaming
  • Supporting different data types for lookup tables ingest
  • Major dependencies updates
  • Improving UI performance for Snowflake Connector's form
  • The private key passphrase will no longer be a required field in the connection form
  • Dependency updates

1.0.0-preview.7

Patch Changes

  • Re-release for the 1.0.0-preview.6 version that couldn't be published due to dependencies bug.

1.0.0-preview.6

Minor Changes

  • Updating dependencies
  • Supporting different data types for lookup tables ingest

Patch Changes

  • Disabling validations on expressions in the lookup file path
  • Fixed race conditions in lookup table creation if the request failed early during streaming
  • The private key passphrase will no longer be a required field in the connection form

1.0.0-preview.5

Minor Changes

  • Updating dependencies
  • Added lookup tables as an option of Grail storage type

1.0.0-preview.4

Minor Changes

  • Replaced allowed users feature by access control settings.
  • Introduce a new, streamlined connection management experience with a modernized interface. This update makes adding and editing connections directly within workflows easier and provides connection control and convenience in one place.
  • Major dependencies updates

1.0.0-preview.3

Minor Changes

  • Added support for overwriting the event.type field of BizEvents

Patch Changes

  • Updated dependencies

1.0.0-preview.2

Minor Changes

  • Removing the allowedUsers property from the connection settings.

Patch Changes

  • Bug fix: Avoiding the "Invalid input value. Undefined is not a UUID" Snowflake error.
  • Dependency updates

1.0.0-preview.1

Patch Changes

  • Dependency updates

1.0.0-preview.0

Major Changes

  • Releasing the Preview version of Snowflake for Workflows

Minor Changes

  • Added support for specifying binding parameters for the Snowflake statement
Dynatrace Hub
Hub HomeGet data into DynatraceBuild your own app
Dynatrace Intelligence - Agentic Operations SystemThe Dynatrace Agentic AI ecosystem
Log Management and AnalyticsKubernetesAI and LLM ObservabilityInfrastructure ObservabilitySoftware DeliveryApplication ObservabilityApplication SecurityBusiness ObservabilityDigital Experience
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed
Partner FinderBecome a partnerDynatrace Developer

All

222 Results filtered by:

Akamai logo

Akamai

Ingest logs and security events from Akamai products.

Extension
Alibaba Cloud logo

Alibaba Cloud

Automatically discover, baseline, and monitor Alicloud environment components.

Extension
Anypoint MQ logo

Anypoint MQ

Gather metrics about your Anypoint MQ Queues.

Extension
Apache ActiveMQ Classic logo

Apache ActiveMQ Classic

Automatic and smart observability for ActiveMQ with trace and metric insights.

Extension
Apache Cassandra logo

Apache Cassandra

Improve Apache Cassandra observability.

Extension
Apache CouchDB logo

Apache CouchDB

Intelligently observe and optimize health and performance of your database.

Extension
Apache Kafka logo

Apache Kafka

Automatic and intelligent observability with trace and metric insights.

Extension
Apache Solr logo

Apache Solr

Open-source enterprise-search platform, written in Java.

Extension
Apache Spark logo

Apache Spark

Enhanced insights for Spark Components.

Extension
Apache Zookeeper logo

Apache Zookeeper

Monitor and analyze your Apache Zookeeper with this JMX-based extension.

Extension
Apigee logo

Apigee

Remotely monitor your Apigee proxies.

Extension
AWS Cloud Monitoring logo

AWS Cloud Monitoring

New and enhanced monitoring capabilities for your AWS cloud platforms.

Extension
AWS Entities for Metric Streaming logo

AWS Entities for Metric Streaming

Analyse metrics in the context of an entity based on AWS Metric Streaming.

Extension
Azure Cloud Monitoring logo

Azure Cloud Monitoring

New and enhanced monitoring capabilities for your Azure cloud platforms.

Extensioncoming soon
Azure Managed Apache Cassandra logo

Azure Managed Apache Cassandra

Gain insights into your Azure Managed Cassandra Instance health and performance.

Extension
Black Duck logo

Black Duck

Ingest Black Duck security events and audit logs.

Extension
Ceph storage logo

Ceph storage

Monitor usage of Ceph storage system at both client side and host level.

Extension
Checkmarx logo

Checkmarx

Ingest Checkmarx security events and audit logs.

Extension
Check Point Firewall logo

Check Point Firewall

Gain insights into the performance of your Check Point Firewall devices.

Extension
Cisco ACI/APIC logo

Cisco ACI/APIC

Get insights into your Cisco Application Centric Infrastructure (ACI).

Extension
Cisco Catalyst Center (DNA Center) logo

Cisco Catalyst Center (DNA Center)

Get insights into the Cisco Catalyst Center infrastructure (f.k.a. DNA Center).

Extension
Cisco Catalyst SD-WAN Manager (Viptela) logo

Cisco Catalyst SD-WAN Manager (Viptela)

Get insights into the Cisco SD-WAN performance through the vManage API.

Extension
Cisco Firepower logo

Cisco Firepower

Monitor Cisco Firepower devices using SNMP.

Extension
Cisco UCS C-Series logo

Cisco UCS C-Series

Get insights into your Cisco UCS C-Series devices.

Extension
Cisco UCS M-Series logo

Cisco UCS M-Series

Get insights into your Cisco UCS M-Series devices.

Extension
Citrix DaaS & Virtual Apps and Desktops logo

Citrix DaaS & Virtual Apps and Desktops

Gain insight into your Citrix DaaS & Virtual Apps and Desktops environments.

Extension
Citrix Netscaler ADC logo

Citrix Netscaler ADC

Remotely monitor your Citrix NetScaler devices.

Extension
Citrix NetScaler SDX logo

Citrix NetScaler SDX

Remotely monitor your Citrix NetScaler SDX devices.

Extension
Cloudflare (extension) logo

Cloudflare (extension)

Collect notification history and various metrics from your Cloudflare accounts.

Extension
Cloud Foundry logo

Cloud Foundry

Monitor your Cloud Foundry resource definitions by connecting to the foundation.

Extension
Confluent Cloud (Kafka) logo

Confluent Cloud (Kafka)

Remotely monitor your Confluent Cloud Kafka Clusters and other resources!.

Extension
Connection Pools: Apache Commons logo

Connection Pools: Apache Commons

Application method of pooling and sharing multiple connections to a database.

Extension
Connection Pools: C3P0 logo

Connection Pools: C3P0

Application server method of pooling and sharing connections to a database.

Extension
Connection Pools: JBoss logo

Connection Pools: JBoss

Application server method of pooling and sharing connections to a database.

Extension
Connection Pools: WebLogic logo

Connection Pools: WebLogic

Application server method of pooling and sharing connections to a database.

Extension
Connection Pools: WebSphere Liberty logo

Connection Pools: WebSphere Liberty

Application server method of pooling and sharing connections to a database.

Extension
Consul Service Mesh (StatsD) logo

Consul Service Mesh (StatsD)

Extend visibility into your Consul Service Mesh instances to monitor health and improve performance.

Extension
Control-M Jobs v2 logo

Control-M Jobs v2

Monitor your Control-M jobs execution status.

Extension
CoreDNS (2.0) logo

CoreDNS (2.0)

Collect important data from your CoreDNS processes.

Extension
Couchbase logo

Couchbase

Couchbase Capella (SaaS) database monitoring.

Extension
CPU Core Monitoring logo

CPU Core Monitoring

Get insights into CPU Core utilization on your OneAgent hosts.

Extension
CrowdStrike logo

CrowdStrike

Ingest CrowdStrike detection findings, threat reports, and audit logs.

Extension
CyberArk logo

CyberArk

Ingest CyberArk audit logs via SIEM integration for reporting and analysis.

Extension
Databricks logo

Databricks

Monitor your Databricks Clusters via its multiple APIs!.

Extension
Databricks Workspace logo

Databricks Workspace

Remotely monitor your Databricks Workspaces!.

Extension
definity logo

definity

Monitor and optimize your Lakehouse, Spark, and Databricks pipelines.

Extension
Defunct Process Monitoring logo

Defunct Process Monitoring

Monitoring defunct processes stuck on your linux servers.

Extension
Dell EMC Isilon - PowerScale logo

Dell EMC Isilon - PowerScale

Monitor your Dell EMC Isilon / Powerscale clusters through the OneFS API.

Extension
Dell EMC PowerMax logo

Dell EMC PowerMax

Monitor PowerMax Arrays for performance and health, with Dell Unisphere API.

Extension
Dell iDRAC logo

Dell iDRAC

Connect to the Redfish API to get insights into your Dell iDRAC environment.

Extension