Connecting a Snowflake warehouse

Prerequisites

Before connecting to Snowflake, perform all of the following actions:

• Create a dedicated database and user in Snowflake.

• Grant schema ownership to the user.

• Assign a single role to the user to prevent execution errors.

• Configure key-pair authentication for the user:

  1. Generate an RSA key pair.

  2. Register the public key with the Snowflake user.

  For more information, see the Snowflake documentation on key-pair authentication.

• Grant the following privileges to the user’s role:

  • EXECUTE TASK - Required for running tasks owned by the role

  • EXECUTE MANAGED TASK - Required for tasks that rely on serverless compute resources

Configure these default values in Snowflake:

• Default database

• Default schema

• Default virtual warehouse

• Default role (if using role-based access)

Connecting to Snowflake

To connect your Snowflake warehouse to Adverity, follow these steps:

1. Go to the Administration page.

2. In the secondary menu, from the Other section, select Warehouse.

3. Click Connect your warehouse.

4. Select Snowflake from the available options.

5. Fill in the following fields:

   Account ID

   Enter your Account ID. You can find it in your Snowflake URL (e.g., xyz123.east-1.snowflakecomputing.com) or in the Snowflake Admin Console.

   Username

   Enter your Snowflake username.

   Key

   Enter your private RSA key in PEM format. The key must include the BEGIN and END headers, for example:

   -----BEGIN PRIVATE KEY----- ...key content... -----END PRIVATE KEY----- 

   This is the private key corresponding to the public key you registered with the Snowflake user.

   Passphrase

   (Optional) Enter the passphrase for your private key, if you set one when generating the key.

   Database

   Enter your target database name.

   Database schema

   Enter the target schema for data storage.

6. Click Test connection to verify the provided parameters.

   Upon successful validation, you’ll see a confirmation message at the bottom of your screen.

7. Review all connection details and click Next.

8. Verify the configuration details and click Connect.

9. Click Yes, connect to Snowflake warehouse in the confirmation dialog.

Managing Snowflake warehouse settings

After connecting, you can store data from your datastreams directly in your Snowflake warehouse.

From the Warehouse tab of the Administration page, you can:

• View connection status

• Contact Support

To rotate your private key or update credentials for your Snowflake warehouse, you can use the multi-warehouse feature. For instructions, see Configuring data warehouses for workspaces.

Troubleshooting