Manage Snowflake Reader Account

The Coveo Platform uses the Snowflake Database to store all UA data. Snowflake is powered by a data platform provided as SaaS and runs on cloud infrastructure. The Snowflake reader account enables you to explore and export linked Coveo Organization’s data.

Each reader account is created for an individual Coveo organization, and therefore only contains UA data related to that organization. Access to the Snowflake reader account for user or service accounts is managed through the Coveo Administration Console. By default, access to the reader account is IP-restricted, therefore an administrator with the required privileges can manage access by creating user accounts and adding allowed IP addresses.

Manage Snowflake User Accounts

Add or Edit Users

  1. In the Raw Data page of the Coveo Administration Console, click the Snowflake Reader Account tab.

  2. In the Snowflake Users panel, click Add User.

  3. Enter the desired user name.

  4. Enter the email.

  5. Click Add.

Once added, a link is sent to the corresponding email address so that the user may set their password. The link is valid for four hours. After the password is set, they must use an allowed IP address in order to access the reader account.

Snowflake users are not the same as members of the Coveo Administration console; they can be either user or service accounts.

Add or Block IP Addresses

  1. In the Raw Data page of the Coveo Administration Console, click the Snowflake Reader Account tab.

  2. In the Snowflake Network Policy panel, click Edit policy.

  3. Under Allowed IP Addresses, enter the IP addresses that you want to allow.

  4. Under Blocked IP Addresses, enter the IP addresses you want to block.

  5. Click Save.

All IP addresses are blocked by default, therefore adding addresses to Blocked IP Addresses lets you block specific addresses within an allowed range.

For example, you add 127.0. 0.1/24 to Allowed IP Addresses . This allows every IP address that starts with "127.0. 0". However, you want to block 127.0. 0.100 and 127.0. 0.200 which fall within that range, therefore you must add them to Blocked IP Addresses.

Snowflake Credits

In the Raw Data page of the Coveo Administration Console, the Snowflake Credits resource monitor displays the monthly credit consumption for the reader account. As an authenticated administrator, you can view the amount of credits remaining based on your account’s consumption for the current month. The credit consumption is determined by the usage of the reader account’s warehouse.

A reader account that is linked to a Coveo organization is automatically assigned a coveo_wh warehouse. The warehouse is required in order to execute SQL queries. SQL queries consume credits and include queries in the Snowflake console, services that perform automatic data extraction, and data exports. The credits consumed by the warehouse count toward your monthly limit.

The default size for a warehouse assigned to a reader account is small. For more information regarding warehouse sizes and their respective credit limits, see Virtual Warehouse Credit Usage.

Access Snowflake Account

You may want to access your Snowflake account for more features such as further data exploration, customized exports, and creating materialized views. On the Raw Data page, you can access your Snowflake account directly by clicking Access Snowflake. The Sign in to Snowflake page will open on a separate tab. You’ll then be able to log in with the credentials specific to the Snowflake interface.

Required Privileges

Privileges required to view or manage the Snowflake reader account.

Action Service - Domain Required access level

View and export data

Snowflake Management

View

Add or edit users

Administrate

Allowed

Snowflake Management

Edit

Add or block IP addresses

Administrate

Allowed

Snowflake Management

Edit

Recommended Articles