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.