Snowflake Data Export Connector

Visier can send data through this connector if the following requirements are met.

Overview

This connector uses Snowflake Spark Connector to send data to Snowflake.

Service account

Create a service account in your target system and assign it the appropriate security access so that Visier can send data through this user.

Note: We only support key-pair authentication because Snowflake blocks sign-ins using single-factor authentication with passwords as of November 2025. For instructions on how to configure key-pair authentication, see Key-pair authentication and key-pair rotation.

Copy

Example: Service user access

1
2
3
4
5
6
7
8
9
10
11
12
-- Grant permissions to the role

USE ROLE SECURITYADMIN;
-- 1. Infrastructure Access
GRANT USAGE ON WAREHOUSE <warehouse name> TO ROLE <role name>;
GRANT USAGE ON DATABASE <database name> TO ROLE <role name>;
-- 2. Target Schema Access
GRANT USAGE ON SCHEMA <database name>.<schema name>  TO ROLE <role name>;
-- 3. The "Action" Permissions
GRANT CREATE TABLE ON SCHEMA <database name>.<schema name>  TO ROLE <role name>;
-- 4. Tag access
GRANT CREATE TAG ON SCHEMA <database name>.<schema name> TO ROLE <role name>;

Connector credentials

Provide the following credentials in Visier. For more information, see Add data export connector credentials in Visier.

Credential	Description	Example
Snowflake URL	The URL to send data to.	example.snowflakecomputing.com
Database	The database to send data to. Useful if you want to restrict access to a specific set of tables in a particular database.	SNOWFLAKE_DATA
Schema	The schema associated with the database. Useful if you want to restrict access to a specific set of tables in a particular schema.	TPCH_SF1
User	The service user's username.	IntegrationUser
Private Key	The generated private key.	-----BEGIN PRIVATE KEY----- ... ----END PRIVATE KEY----
Warehouse	The warehouse to use.	SAMPLEWAREHOUSE
Role (Optional)	The database role that provides access to securable objects.
Key Passphrase (Optional)	The passphrase for the encrypted private key.