Snowflake for Workflows is currently in preview release and is available to selected customers only. If you would like to share feedback or ideas, join the preview by signing up via the Request access to Snowflake Workflow Connector form or contacting your Customer Success Manager.
For more information, see preview releases.
After you join the preview program for Snowflake for Workflows, we'll provide Hub subscription details. With those subscription details, follow the Add Hub subscriptions procedure to you activate the capability.
Preview
Your Dynatrace environment can integrate with a Snowflake instance using Snowflake for Workflows .
With this integration, you can execute statements on your database and load results into Grail.
To install Snowflake for Workflows, you need the app-engine:apps:install
permission.
To improve traceability and auditability, use a dedicated Snowflake service user to access your Snowflake database.
To add connection settings, you need the following permissions:
ALLOW settings:objects:read, settings:objects:write, settings:schemas:read WHERE settings:schemaId = "app:dynatrace.snowflake.connector:connection"
For more information, see Permissions and access.
Connections are shared and can be used by all users with app-settings
read permissions.
To integrate with a Snowflake database, you need to install Snowflake for Workflows from Dynatrace Hub.
To set up the connection between Snowflake and your Dynatrace environment
*.snowflakecomputing.com
.To authorize the connection to Snowflake
Get the credentials for the Snowflake instance. The following authentication methods are supported:
Key-Pair JWT — This method uses a private key to generate a JWT token to authenticate into the Snowflake. For more information, see Using key-pair authentication.
External OAuth client_credentials
flow — This method uses the preconfigured client and resource on the external OAuth server supported by Snowflake. For more information, see External OAuth overview.
In Dynatrace, go to Settings > Dynatrace Apps > Snowflake Connections.
For more information on how to configure Azure to issue OAuth tokens on behalf of a client to access Snowflake, see How to configure Azure to issue OAuth tokens on behalf of a client to access Snowflake.
Select Add item and provide a name for the connection, the URL of the Snowflake instance, and, depending on the credential method you choose, either the private key and account settings or the OAuth client_credentials
flow parameters.
optional Specify a list of email addresses of the users you want to allow to execute statements using the connection. By default, every user can use it.
Select Save.