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
All (914)Log Management and AnalyticsKubernetesAI and LLM ObservabilityInfrastructure ObservabilityApplication ObservabilityApplication SecurityBusiness ObservabilityDigital Experience
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed
Partner FinderBecome a partnerDynatrace Developer

Software Delivery

Empower DevOps platform engineers, SREs, and development teams to deliver higher quality software, faster, and more securely.

Popular integrations

See more (1)
GitHub logo

GitHub

Automate GitHub issues, pull requests, and workflows from Dynatrace.

Jira logo

Jira

Open, update, and close Jira tickets automatically from Dynatrace Workflows.

Jenkins logo

Jenkins

Trigger Jenkins builds and monitor job status from Dynatrace Workflows.

GitLab logo

GitLab

Amend files in GitLab repositories, trigger pipelines, and manage issues.

Slack logo

Slack

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

ServiceNow logo

ServiceNow

Create and manage ServiceNow incidents from Dynatrace Workflows.

More options

Workflows logo

Workflows

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

Keptn logo

Keptn

Event-based control plane for continuous delivery and automated operations.

Configuration as Code logo

Configuration as Code

Manage observability and security configurations as code via Terraform or Monaco.

Site Reliability Guardian logo

Site Reliability Guardian

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

Service-Level Objectives logo

Service-Level Objectives

Manage SLOs and error budgets to ensure service performance and reliability SLAs.

More resources

AWS Connector logo

AWS Connector

Automate your AWS infrastructure with actions across EC2, S3, Lambda, and more.

Claude Connector for Workflows logo

Claude Connector for Workflows

Connect with Claude and send prompts for further analysis using Workflows.

CI/CD Observability logo

CI/CD Observability

Monitor CI/CD pipelines such as Azure Devops, Gitlab, Github and more.

Observability for Developers on Cursor logo

Observability for Developers on Cursor

Get Real time Code-Level data directly to your Cursor IDE.

Email logo

Email

Send out-of-the-box targeted Emails with workflows.

Gemini Connector for Workflows logo

Gemini Connector for Workflows

Connect with Gemini and send prompts for further analysis using Workflows.

GitHub Copilot Coding Agent logo

GitHub Copilot Coding Agent

Automate vulnerability remediation and boost developer productivity.

GitHub Copilot Custom Agent logo

GitHub Copilot Custom Agent

Automate your development workflows with specialized agent definitions.

Observability for Developer on JetBrains logo

Observability for Developer on JetBrains

Get real-time code-level data directly to your Jetbrains IDE.

Kubernetes Connector logo

Kubernetes Connector

Automate your Kubernetes clusters: Delete failed pods and restart deployments.

Microsoft 365 logo

Microsoft 365

Send targeted emails from workflows using your Microsoft 365 account.

OpenAI Connector for Workflows logo

OpenAI Connector for Workflows

Connect with OpenAI and send prompts for further analysis using Workflows.

Ownership logo

Ownership

Enables the import of and access to ownership information of entities.

Pagerduty for Dynatrace Workflows logo

Pagerduty for Dynatrace Workflows

Streamline incident management with automated Pageruty workflows.

Red Hat Ansible logo

Red Hat Ansible

Integrate with Red Hat Ansible (EDA, AAC, AWX) to trigger job templates.

Snowflake for Workflows logo

Snowflake for Workflows

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

Observability for Developers on VSCode logo

Observability for Developers on VSCode

Get Real time Code-Level data directly to your VSCode IDE.

Cursor IDE logo

Cursor IDE

Boost developer productivity and get real-time, code-level insights into Cursor.

Observability for Developers on Windsurf logo

Observability for Developers on Windsurf

Get real-time code-level data directly to your Windsurf IDE.

Are you looking for something different?

We have hundreds of apps, extensions, and other technologies to customize your environment

Extend your knowledge

Learn the Dynatrace Query Language

Learn the Dynatrace Query Language

Explore data, discover patterns, anomalies and outliers, and create statistical modeling with DQL, our powerful query language.
Learn DQL
Solve problems with custom apps

Solve problems with custom apps

Dynatrace Developer makes it easy to create custom apps for your organisation. Start with one of our templates or use your own code.
Build apps