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

65 Results

Found in 'All'

Databases logo

Databases

Monitor databases, prevent issues, and resolve incidents quickly in real time.

App
  • database
  • db
  • google cloud sql
  • hanadb
  • monitoring
  • mssql
  • MySQL
  • oracle
  • PostgreSQL
  • rds
  • saas
Oracle Database logo

Oracle Database

Observe, analyze and optimize the usage, health and performance of your database.

Extension
  • database
  • logs
  • monitoring
  • oracle
  • sql
Azure SQL Database logo

Azure SQL Database

Managed cloud database provided as part of Microsoft Azure.

Technology
  • cloud
Azure Database for MySQL logo

Azure Database for MySQL

Full observability of MySQL servers and database instances to ensure database health and performance.

Technology
  • cloud
Database Operations Agent logo

Database Operations Agent

Identify application slowdowns by automatically analyzing database performance.

Technology
  • database
  • agentic-operations-system
  • agentic-workflows
  • AI
  • db
  • MCP
  • Model Context Protocol
  • readymade-agent
  • sql
Custom database extension logo

Custom database extension

Execute generic database queries and ingest metrics and logs to Dynatrace.

Technology
  • database
  • Custom
  • extension
Azure Database for Maria DB logo

Azure Database for Maria DB

Full coverage of performance for critical workloads with AI-problem detection, availability, and more.

Technology
  • cloud
Azure Database for PostgreSQL logo

Azure Database for PostgreSQL

Full insight into database performance for critical workloads with AI-problem detection and more.

Technology
  • cloud
AWS Database Migration Service logo

AWS Database Migration Service

Makes it easy to migrate relational databases, and other types of data stores.

Technology
  • cloud
Amazon Quantum Ledger Database (QLDB) logo

Amazon Quantum Ledger Database (QLDB)

Ledger by a central trusted authority that provides an immutable, and cryptographically verifiable transaction log.

Technology
  • cloud
SAP HANA Database (remote monitoring) logo

SAP HANA Database (remote monitoring)

Easily understand the health and performance of your SAP HANA databases.

Extension
  • database
  • extension
  • hanadb
  • sap
  • sql
Amazon Relational Database Service (RDS) logo

Amazon Relational Database Service (RDS)

Instant insights and unified monitoring for optimal Amazon RDS performance.

Technology
  • database
  • log-ingest-integration-cloud:relational:database:service
  • amazon
  • aws
Couchbase logo

Couchbase

Couchbase Capella (SaaS) database monitoring.

Extension
  • database
  • full-stack
  • monitoring
  • noSQL
  • OneAgent
  • performance
IBM DB2 for LUW (remote monitoring) logo

IBM DB2 for LUW (remote monitoring)

Remotely collect monitoring metrics from your DB2 databases.

Extension
  • database
  • db2
  • ibm
  • linux
  • windows
Oracle Base DB and Autonomous DB on OCI logo

Oracle Base DB and Autonomous DB on OCI

Monitor health of the Oracle Base Service and Autonomous Database.

Extension
  • database
  • cloud
  • cloud-and-infrastructure
  • OCI
  • oracle
IBM DB2 logo

IBM DB2

Data management products, including database servers, developed by IBM.

Technology
  • database
  • ibm
  • mainframe
  • z/OS
Connection Pools: JBoss logo

Connection Pools: JBoss

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

Extension
  • database
  • connection pool
  • java
  • jboss
  • JMX
  • OneAgent
  • open-source
  • pool
  • red-hat
  • wildfly
Connection Pools: C3P0 logo

Connection Pools: C3P0

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

Extension
  • database
  • c3p0
  • connection pool
  • java
  • JMX
  • OneAgent
  • open-source
  • pool
Connection Pools: WebSphere Liberty logo

Connection Pools: WebSphere Liberty

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

Extension
  • database
  • connection pool
  • ibm
  • java
  • JMX
  • liberty
  • OneAgent
  • pool
  • websphere
Connection Pools: WebLogic logo

Connection Pools: WebLogic

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

Extension
  • database
  • connection pool
  • java
  • JMX
  • OneAgent
  • oracle
  • pool
  • weblogic
Apache CouchDB logo

Apache CouchDB

Intelligently observe and optimize health and performance of your database.

Extension
  • database
Connection Pools: Apache Commons logo

Connection Pools: Apache Commons

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

Extension
  • database
  • apache
  • apache commons
  • connection pool
  • java
  • JMX
  • OneAgent
  • open-source
  • pool
Memcached logo

Memcached

Distributed caching system used to speed up dynamic database-driven websites.

Extension
  • database
  • cache
  • Memcached
Sybase ASE logo

Sybase ASE

Monitor Sybase ASE database for performance and health, using remote monitoring.

Extension
  • database
  • sap
  • sybase
MariaDB logo

MariaDB

Observe, analyze and optimize the usage, health and performance of your database.

Technology
  • database
  • full-stack
  • monitoring
Amazon Aurora logo

Amazon Aurora

Relational database service developed and offered by Amazon Web Services.

Technology
  • cloud
LanceDB logo

LanceDB

Monitor the performance of your multimodal AI database powered by LanceDB.

Technology
Pinecone logo

Pinecone

Gain insight into your Pinecone vector databases to build knowledgeable AI.

Technology
Milvus logo

Milvus

Gain insights about vector database resource utilization and cache behavior.

Technology
Java JDBC logo

Java JDBC

Application programming interface for the Java, defines access to a database.

Technology
  • java
Amazon DynamoDB logo

Amazon DynamoDB

Fully managed NoSQL database service that supports key-value and data structure.

Technology
  • amazon
  • log-ingest-integration-cloud:aws:dynamodb
Amazon Neptune logo

Amazon Neptune

Fast, reliable, fully managed graph database built for highly connected datasets.

Technology
  • cloud
Chroma logo

Chroma

Gain insights into the health of your vector and embedding databases from Chroma.

Technology
MySQL logo

MySQL

Automatically and intelligently observe, analyze and optimize how your the usage, health and performance of your database.

Technology
  • database
  • full-stack
  • monitoring
  • performance
  • web
Amazon Keyspaces for Apache Cassandra logo

Amazon Keyspaces for Apache Cassandra

Scalable, highly available, and managed Apache Cassandra–compatible database service.

Technology
  • cloud
WordPress logo

WordPress

Content management system written in PHP and paired with a MySQL or MariaDB database.

Technology
  • cms
  • php
  • web
Neo4j logo

Neo4j

Extend observability with PurePath® distributed traces by seamlessly integrating OpenTracing data emitted by the Neo4j graph database.

Technology
  • database
  • java
  • neo4j
  • opentracing
  • PurePath
Azure Synapse Analytics logo

Azure Synapse Analytics

Cloud-based, scale-out, relational database capable of processing massive volumes of data.

Technology
  • cloud
Azure SQL Managed logo

Azure SQL Managed

Full observability into cloud database performance and automated monitoring for Azure SQL Managed.

Technology
  • cloud
Amazon DocumentDB logo

Amazon DocumentDB

Amazon DocumentDB (with MongoDB compatibility) is a fast, reliable, and fully managed database service.

Technology
  • cloud
Azure Cosmos DB logo

Azure Cosmos DB

Fully managed and serverless distributed database supporting open-source PostgreSQL, MongoDB, and Apache Cassandra.

Technology
  • cloud
Snowflake for Workflows logo

Snowflake for Workflows

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

App
  • database
  • automation
  • connector
  • connectors
  • snowflake
  • workflow
  • workflow action
  • workflow actions
  • workflows
Snowflake logo

Snowflake

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

Extension
  • database
  • logs
  • snowflake
  • sql
Elasticsearch logo

Elasticsearch

Monitor Elasticsearch Clusters, Nodes, Indexes, remotely or locally, via API.

Extension
  • database
  • Elasticsearch
  • search
Redis Enterprise - Prometheus logo

Redis Enterprise - Prometheus

Monitor Redis Enterprise with the official Redis Prometheus exporter.

Extension
  • database
  • cache
  • noSQL
  • Redis
  • redis
  • replication
  • shard
PostgreSQL logo

PostgreSQL

Monitor your Postgres performance via our new EF2.0 extension framework.

Extension
  • database
  • extension
  • logs
  • postgres
  • query
  • sql
Custom Extensions Creator logo

Custom Extensions Creator

Create custom extensions with a few clicks.

App
  • database
  • app
  • custom queries
  • datasource
  • extensions
  • JMX
  • Prometheus
  • queries
  • query
  • snmp
  • snmptraps
  • sql
  • WMI
Oracle GoldenGate logo

Oracle GoldenGate

Monitor Oracle GoldenGate for performance, usage, and availability.

Extension
  • database
  • oracle
  • sql
Oracle Exadata logo

Oracle Exadata

Monitor Oracle Exadata systems for performance, usage and availability.

Extension
  • database
  • exadata
  • oracle
MySQL (remote monitoring) logo

MySQL (remote monitoring)

Remotely monitor your MySQL instances, collect key KPIs and slow queries details.

Extension
  • database
  • MySQL