Snowflake

Cloud-native data platform built for the modern data stack, enabling seamless data validation across your enterprise.

Overview

Snowflake is a leading cloud data platform that stores and analyzes structured and semi-structured data. It delivers unlimited scalability, flexible performance, and secure data sharing capabilities. The Data Testing connector provides comprehensive Snowflake integration for validation workflows.

Perfect for:

• ✅ Cloud data warehouse validation

• ✅ Multi-region data lakes

• ✅ Shared data validation

• ✅ Cross-platform migrations

---

⚙️ Configuration Parameters

Parameter	Description	Required	Example
Account	Snowflake account identifier	✅ Yes	xy12345.east-us-2.azure
Warehouse	Virtual warehouse for queries	✅ Yes	COMPUTE_WH
Database	Target database name	✅ Yes	ANALYTICS_DB
Schema	Target schema name	✅ Yes	PUBLIC
Username	Snowflake user account	✅ Yes	validation_user
Password	User password (if using password auth)	⚠️ Optional	••••••••••
RSA Key File	RSA private key path (.p8)	⚠️ Optional	/path/to/key.p8
Fingerprint	Public key fingerprint	⚠️ Optional	SHA256:xxxx...
Query	SQL SELECT statement	✅ Yes	See examples below

Configuration Screenshot

Snowflake Configuration

---

🔐 Authentication Methods

Username + Password

Standard authentication using username and password

1. Enter your Snowflake username

2. Provide the associated password

3. Click Test Connection

4. Proceed to query configuration

Simple and straightforward for development environments.

RSA Key Pair

---

🔑 Setting Up RSA Key Authentication

Security Best Practice: Use RSA key authentication for production environments.

Step 1: Generate RSA Key Pair

Generate a 2048-bit RSA private key:

openssl genrsa -out rsa_key.p8 2048

Step 2: Extract Public Key

Extract the public key from the private key:

openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub

Step 3: Generate Fingerprint

Calculate the SHA256 fingerprint of your public key:

openssl rsa -in rsa_key.p8 -pubout -outform DER | openssl dgst -sha256 -binary | openssl enc -base64

Save the output - this is your fingerprint.

Step 4: Register Public Key in Snowflake

Execute this SQL in your Snowflake account:

-- Replace with your public key content and username
ALTER USER validator_user SET RSA_PUBLIC_KEY='<paste_public_key_here>';

Verify the key was set:

DESCRIBE USER validator_user;

Step 5: Configure in Data Testing

1. Upload or provide path to RSA private key (.p8)

2. Enter the fingerprint you calculated

3. Click Test Connection

4. Proceed with query configuration

---

📖 Getting Started

Step 1: Gather Snowflake Details

Obtain these details from your Snowflake administrator:

• ✅ Account identifier (format: xy12345.region.cloud)

• ✅ Warehouse name (for query execution)

• ✅ Database and schema names

• ✅ Username and authentication method

• ✅ Network access permissions

Step 2: Create Service User (Recommended)

-- Create a dedicated validation user
CREATE USER validator_user PASSWORD = 'secure_password';

-- Grant necessary permissions
GRANT USAGE ON DATABASE analytics_db TO ROLE validation_role;
GRANT USAGE ON SCHEMA analytics_db.public TO ROLE validation_role;
GRANT SELECT ON ALL TABLES IN SCHEMA analytics_db.public TO ROLE validation_role;

-- Assign role to user
GRANT ROLE validation_role TO USER validator_user;

Step 3: Configure the Connector

1. Navigate to your job configuration

2. Select Snowflake as the data source

3. Enter account, warehouse, database, and schema

4. Choose authentication method

5. Click Test Connection

6. Write your data query

7. Click Execute Query

---

Related Documentation

• SQL Connectors Guide

• Data Source Overview

• Create Compare Job