Collecting data from Snowflake

This guide explains how to collect data from Snowflake. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.

  • Snowflake can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.

Creating a datastream to collect data from Snowflake

The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from Snowflake.

Authorization: Allow Adverity to access Snowflake

To set up a new authorization to fetch data from Snowflake, follow these steps:

  1. In the Authorization step of the datastream wizard, click Access Snowflake using your credentials.

  2. Click Next.

  1. Choose how you want to access Snowflake. The information you need to provide in the next step depends on the option you choose:

    • To access Snowflake using your username and password, click Snowflake.

    • To access Snowflake using your username and private key, click Snowflake (Key Pair).

    • To access Snowflake using OAuth2 authentication, click Snowflake (OAuth2).

  2. Fill in the following fields. The fields you need to fill in depend on the authorization option you selected in the previous step:

    Hostname - all Snowflake authorization methods

    The server name of the database from which you want to collect data. Use the following format for the hostname:

    {account_name}.{region_id}.snowflakecomputing.com

    If your region is US-WEST, region_id is not required:

    {account_name}.snowflakecomputing.com

    Username - Snowflake and Snowflake (Key Pair)

    The username of the Snowflake account.

    Password - Snowflake

    The password of the Snowflake account.

    Private Key - Snowflake (Key Pair)

    The Private Key associated with one of the public keys assigned to the Snowflake account. The Private Key must be PEM encoded and include boundaries, for example: (-----BEGIN[Private Key]-----END).

    Key password - Snowflake (Key Pair)

    The password to decrypt the Private Key. Leave empty if the Private Key is not encrypted.

    Client ID - Snowflake (OAuth2)

    The client ID of the Snowflake account. For more information on finding the client ID, see the Snowflake documentation.

    Client secret - Snowflake (OAuth2)

    The client secret of the Snowflake account. For more information on finding the client secret, see the Snowflake documentation.

Configuration: Choose the data you want to collect from Snowflake

To choose what data to collect and customize the Snowflake datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  1. In Query, enter an SQL query defining what data to fetch.

  2. In Role, select the Snowflake user role. If left empty, the role is set based on the Snowflake enforcement model.

  3. In Warehouse, select the name of the warehouse from which to fetch data.

  4. In Database, select the name of the database from which to fetch data.

  5. In Schema, select the schema used in the database.

What's next?