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.
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 Snowflake, follow these steps:
to fetch data from-
In the Authorization step of the datastream wizard, click Access Snowflake using your credentials.
-
Click Next.
-
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).
-
-
Fill in the following fields. The fields you need to fill in depend on the
option you selected in the previous step:-
Hostname - all Snowflake
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:
-
(Optional) Rename your datastream.
-
In Query, enter an SQL query defining what data to fetch.
-
In Role, select the Snowflake user role. If left empty, the role is set based on the Snowflake enforcement model.
-
In Warehouse, select the name of the warehouse from which to fetch data.
-
In Database, select the name of the database from which to fetch data.
-
In Schema, select the schema used in the database.
What's next?
-
Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.
-
Transform your data to meet your needs by creating and applying enrichments to your datastream.
-
Load your data into Explore & Present to visualize your data in Adverity
-
Load your data into an external destination of your choice