Snowflake

Snowflake cloud data warehouse connector.

Configuration Parameters

• Account – Snowflake account identifier (e.g., xy12345.east-us-2.azure).

• Warehouse – Virtual warehouse name for query execution.

• Database – Target database name.

• Schema – Target schema name.

• Username – Snowflake user account.

• Password – (Optional) User password for password-based authentication.

• RSA Key File – (Optional) RSA private key file path (.p8 format).

• Fingerprint – (Optional) Public key fingerprint.

• Query – SQL query for data retrieval.

Snowflake Configuration

Authentication Options

• Username + Password – Standard authentication.

• RSA Key Pair + Fingerprint – Secure key-pair authentication.

⚠️ Important: Register the public key in the Snowflake user profile before using RSA authentication.

Setting Up RSA Key Authentication

openssl genrsa -out rsa_key.p8 2048

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

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

ALTER USER SERVICE_USER SET RSA_PUBLIC_KEY='<public_key>';