Connecting an external data warehouse

Connecting an external data warehouse#

Introduction#

In Adverity, a warehouse is used as an internal destination for your data before loading it to data sharing destinations. By default, Adverity stores data in Adverity Data Storage (ADS), a data warehouse managed by Adverity. Instead of storing your data in ADS, you can store it in your own Snowflake warehouse. This integration is particularly valuable if you:

  • Need to meet specific compliance, security, or data sovereignty requirements

  • Have invested in Snowflake as your cloud data infrastructure

  • Want to eliminate data duplication and reduce infrastructure costs

When you connect your Snowflake warehouse to Adverity:

  • Collected data is written to your Snowflake warehouse instead of ADS when loading to storage is enabled for the datastream.

  • You can send this data to data sharing destinations, for example, Power BI and Tableau, directly from Snowflake.

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 data warehouse#

  1. Go to the Administration page.

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

  3. Select Use your Snowflake warehouse from storage options.

    image1

  4. 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.

  5. Click Test connection to verify the provided parameters.

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

  6. Review all connection details and click Connect.

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

    image2

Note

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

Managing 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.

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