Overview

During installation, a SQL Server database server is set up, which stores the results of test and profile set executions locally. If you are interested in storing results in the cloud, we offer the option to store result records in Snowflake.

Choosing a Location

Local Storage: Test Results and Profile Results will be stored in the Validatar repository.
Snowflake: Test Results and Profile Results will be stored in Snowflake. This option is not available until the Snowflake configuration has been completed and verified below.

Configuring Snowflake

Prerequisites

SnowSQL needs to be installed on the Validatar web server before changing the storage location to Snowflake.
A Snowflake admin must run the generated setup script in Snowflake to initialize the environment.

SnowSQL Note

Files are transferred to Snowflake using SnowSQL. SnowSQL version 1.2.16 or higher is required.

Setting up SnowSQL on Windows

Click here to view Snowflake's documentation on installing SnowSQL.

Note: The installer may fail to initialize log. If this occurs,

Go to: %USERPROFILE%\.snowsql\
Update the config file by replacing this line: log_file = ../snowsql_rt.log
With this line: log_file = %USERPROFILE%\.snowsql\log\snowsql_rt.log

Configure the Connection

All parameters are required to configure the connection.

Connection Parameters	Description
Account Name	The account name is found in the URL used to log into Snowflake, excluding "*https://" or ".snowflakecomputing.com*". The account name must include the region.
Database Name	The database that will store the results. The database does not have to exist beforehand.
Schema Name	The schema that will store the results. The schema does not have to exist beforehand.
Role Name	The assigned user role used to. The role cannot be one of the following Snowflake system-defined roles: ACCOUNTADMIN SECURITYADMIN USERADMIN SYSADMIN PUBLIC
Username
Warehouse Name	The warehouse that will store the results. The warehouse does not have to exist beforehand.
Temporary File Path	Temporary files will be created in this folder before being imported into Snowflake.

Running the Setup Scripts

Complete the following steps to configure Snowflake.

After configuring the Snowflake Connection in Step 2, click Generate Setup Script.
Copy the setup script to the clipboard.
Paste the setup script into an open Snowflake worksheet.
Setup a password for the user by substituting [[REPLACE]] in the setup script with the actual password.
Run the setup script in Snowflake.
In Validatar, generate the public/private keys that will authenticate SnowSQL.
Click View Public Key/Script and copy the script to the clipboard.
Paste the key script into an open Snowflake worksheet
Run the key script.

You're done with the Snowflake setup! Next is validating the connection.

Public/Private Key Note

You can regenerate the public/private keys as frequently as you want, but you will need to regenerate and rerun the script to assign the new public key to the Validatar user account in Snowflake.

Validate the Connection

The last step to set up Snowflake is validating the connection. Click Validate Settings, and Validatar will complete the following steps:

Verifying that the Snowflake account exists
Verifying that SnowSQL is installed
Verifying the Snowflake login
Verifying the database, role, and warehouse
Creating the schema, table, stages, and pipes
Verifying access to the temporary file path
Verifying that a sample file can be uploaded/imported to Snowflake