Connecting a Snowflake warehouse

Connecting a Snowflake warehouse#

This guide explains how to connect your Snowflake warehouse to Adverity.

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.

  • 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)

Note

Set up these default values in Snowflake before connecting, as they cannot be modified through Adverity.

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.

    Database

    Enter your dedicated database name.

    Schema

    Enter the target schema for data storage.

    Username and Password

    Enter your Snowflake user credentials.

  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.

Note

After confirmation, the warehouse configuration can only be modified through Adverity Support. Ensure all details are correct before proceeding.

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:

  • Update warehouse password

  • View connection status

  • Contact Support

Note

To change database, schema, or other connection parameters, contact Adverity Support through the Warehouse tab or Adverity Help Center.

Switching warehouse providers#

If you want to use a different warehouse provider instead of your currently connected Snowflake warehouse, you must contact Adverity Support. Direct switching between warehouse providers is not available through the user interface.

Troubleshooting#

Connection validation error#

If you receive a connection validation error:

  1. Verify your Snowflake user has these permissions:

    • Schema ownership

    • Warehouse usage rights

    • Single role assignment

    • Default database access

    • Default schema access

    • Default virtual warehouse access

    • Default role permissions

  2. Review the configuration status table for specific error details.

  3. Click Expand error for comprehensive error information.

  4. Contact support if issues persist.

Contents