Contents x
    Result Storage
    • 20 Mar 2024
    • 2 Minutes to read
    • PDF
    Contents

    Result Storage

    • Updated on 20 Mar 2024
    • 2 Minutes to read
    • PDF
    Article summary

    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

    1.  SnowSQL needs to be installed on the Validatar web server before changing the storage location to Snowflake.
    2.  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 ParametersDescription
    Account NameThe 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 NameThe database that will store the results. The database does not have to exist beforehand.
    Schema NameThe schema that will store the results. The schema does not have to exist beforehand.
    Role NameThe assigned user role used to. The role cannot be one of the following Snowflake system-defined roles:
    • ACCOUNTADMIN
    • SECURITYADMIN
    • USERADMIN
    • SYSADMIN
    • PUBLIC
    Username
    Warehouse NameThe warehouse that will store the results. The warehouse does not have to exist beforehand.
    Temporary File PathTemporary files will be created in this folder before being imported into Snowflake.

    Running the Setup Scripts

    Complete the following steps to configure Snowflake.

    1. After configuring the Snowflake Connection in Step 2, click Generate Setup Script.
    2. Copy the setup script to the clipboard.
    3. Paste the setup script into an open Snowflake worksheet.
    4. Setup a password for the user by substituting [[REPLACE]] in the setup script with the actual password.
    5. Run the setup script in Snowflake.
    6. In Validatar, generate the public/private keys that will authenticate SnowSQL.
    7. Click View Public Key/Script and copy the script to the clipboard.
    8. Paste the key script into an open Snowflake worksheet
    9. 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:

    1. Verifying that the Snowflake account exists
    2. Verifying that SnowSQL is installed
    3. Verifying the Snowflake login
    4. Verifying the database, role, and warehouse
    5. Creating the schema, table, stages, and pipes
    6. Verifying access to the temporary file path
    7. Verifying that a sample file can be uploaded/imported to Snowflake
    Was this article helpful?
    What's Next