Skip to main content

Snowflake Documentation

Real-time connection

With the Real-time connection, you can directly connect to your Snowflake database and, after configuring your Snowflake account details, get live data insights. The real-time connection allows you to access all Unravel features at once, perform real-time monitoring, receive notification alerts, and observe live insights without any requirement for account admin access.

Also see, Choosing a connection to Upload Snowflake dataChoosing a connection to upload Snowflake data

Getting live data using a Real-time connection

The following steps are involved in setting up an Unravel account for Snowflake using the Real-time connection.

  1. Access the Unravel UI using the login credentials you received in the email when you created the Unravel Snowflake free account. The data fields are empty when you access Unravel UI for the first time.

  2. Click manage1.png on the upper right side and select Snowflake configuration.

  3. Select the Real-time option.

  4. Enter the following details:

    Field

    Description

    Snowflake account

    User

    Enter the username to access the Snowflake account.

    Password

    Enter the passcode to access the Snowflake account.

    Account

    Specify the Snowflake user account from where you want to get live data for monitoring.

    Role

    Specify a role associated with this user account for Unravel to access the correct Snowflake data warehouse.

    Parameters

    Database name

    Specify the Snowflake database where Unravel accesses metadata.

    Schema name

    Specify the Snowflake schema in your database.

    Warehouse for analysis

    Specify a warehouse from where Unravel can fetch metadata (monitor and telemetry data). The minimum warehouse size required by Unravel is X-small.

    Look back

    Set the number of days, in the past, from today for which the metadata should be fetched.

    Unravel Operations

    Database

    Specify the Snowflake database where Unravel will access metadata.

    Schema

    Specifiy the Snowflake schema in your database.

    Set Snowflake credit cost

    Credit cost

    Set the USD cost of your Snowflake credits.

  5. Click Save to save the settings. After you save the setting, Unravel connects to the configured Snowflake account and starts polling the data. New data can be seen on the Queries and Warehouse pages on Unravel UI. The duration of the entire data loading process depends on both the volume of data and the specified look-back period.