Snowflake Connector

Use Snowflake as a destination (load data in) or a source (read existing tables).

Supported sync modes

As destination	Write modes
	Append, Upsert, Replace

As source	Full Refresh	Incremental
	✅	✅

How to connect

Connect with username + password or a key pair.

Username + Password
Key pair

Step 1 — Create a dedicated Snowflake user

We recommend creating a separate user and role so you can control exactly what Zwiron can access.Run this in a Snowflake worksheet (replace the placeholders with your values):

-- Create a role for Zwiron
CREATE ROLE zwiron_role;

-- Create a user
CREATE USER zwiron_user
  PASSWORD = 'your_strong_password'
  DEFAULT_ROLE = zwiron_role
  DEFAULT_WAREHOUSE = 'your_warehouse';

-- Grant the role to the user
GRANT ROLE zwiron_role TO USER zwiron_user;

-- Grant warehouse access
GRANT USAGE ON WAREHOUSE your_warehouse TO ROLE zwiron_role;

-- Grant database and schema access
GRANT USAGE ON DATABASE your_database TO ROLE zwiron_role;
GRANT USAGE ON SCHEMA your_database.your_schema TO ROLE zwiron_role;

-- Grant table permissions
GRANT CREATE TABLE ON SCHEMA your_database.your_schema TO ROLE zwiron_role;
GRANT INSERT, UPDATE, DELETE, SELECT ON ALL TABLES IN SCHEMA your_database.your_schema TO ROLE zwiron_role;
GRANT INSERT, UPDATE, DELETE, SELECT ON FUTURE TABLES IN SCHEMA your_database.your_schema TO ROLE zwiron_role;

Step 2 — Connect in Zwiron

Go to Connections → Add Connection → Snowflake
Fill in the connection fields:

Field	What to enter
Account	Your account identifier, e.g. `abc12345.us-east-1` or `orgname-accountname`
Auth type	`password`
User	`zwiron_user`
Password	The password you set above
Database	Your target database name
Warehouse	Your warehouse name
Schema	Target schema (defaults to `PUBLIC`)
Role	`zwiron_role`

Click Test Connection — you should see “Connection successful”
Click Next to name and save the connection

Key pair auth uses an RSA private key instead of a password. Generate a key, assign the public key to the Snowflake user, then paste the PEM private key into Zwiron.

ALTER USER zwiron_user SET RSA_PUBLIC_KEY='MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8A...';

In Zwiron, set Auth type to key_pair, User to that Snowflake user, and Private key to the matching PEM (PKCS#8 or PKCS#1). Account, database, warehouse, schema, and role are the same as password auth.

Finding your account identifier

Your account identifier is shown in Snowflake under Admin → Accounts. Hover over your account name to see the full identifier. The format is usually one of:

abc12345.us-east-1 (legacy)
orgname-accountname (newer organisation accounts)

Not sure of your full identifier? Run this in a Snowflake worksheet:

SELECT CURRENT_ORGANIZATION_NAME() AS org, CURRENT_ACCOUNT_NAME() AS account;

Zwiron account is org-account (for example rzvygjb-qv57800).

How Zwiron writes to Snowflake

Zwiron uses Snowflake’s bulk COPY INTO for high-throughput writes — data is staged internally then loaded in one shot. This is far faster than row-by-row inserts. For upsert mode, Zwiron uses a staging table + MERGE INTO pattern:

Write incoming rows to a temporary staging table
MERGE INTO the target table using the primary key
Drop the staging table

Schema management

Zwiron creates tables automatically if they don’t exist, mapping source types to Snowflake types:

Source type	Snowflake type
INTEGER / BIGINT	NUMBER
FLOAT / DOUBLE	FLOAT
VARCHAR / TEXT	VARCHAR
BOOLEAN	BOOLEAN
DATE	DATE
TIMESTAMP	TIMESTAMP_NTZ
JSON / JSONB	VARIANT
BYTES / BLOB	BINARY

Troubleshooting

Zwiron lists only resources that your role has access to. If you don’t see a database, schema, or warehouse in the dropdown after connecting:

Check which role is active — the dropdown only shows resources visible to that role
Grant the missing permissions in a Snowflake worksheet:

-- Grant database access
GRANT USAGE ON DATABASE your_database TO ROLE your_role;

-- Grant schema access
GRANT USAGE ON SCHEMA your_database.your_schema TO ROLE your_role;
GRANT CREATE TABLE ON SCHEMA your_database.your_schema TO ROLE your_role;

-- Grant warehouse access
GRANT USAGE ON WAREHOUSE your_warehouse TO ROLE your_role;

If the schema does not exist yet, create it first:

CREATE SCHEMA IF NOT EXISTS your_database.your_schema;
GRANT ALL PRIVILEGES ON SCHEMA your_database.your_schema TO ROLE your_role;
GRANT ALL PRIVILEGES ON FUTURE TABLES IN SCHEMA your_database.your_schema TO ROLE your_role;

After granting permissions, go back to Zwiron and re-test the connection — the resources will appear.

Warehouse suspended / auto-resume not enabled

Enable auto-resume: ALTER WAREHOUSE your_warehouse SET AUTO_RESUME = TRUE;

Insufficient privileges

Make sure the Zwiron role has CREATE TABLE on the schema and INSERT, UPDATE, DELETE on the tables. Re-run the setup SQL from the password tab above.

Account identifier format

Use the full identifier including cloud region, e.g. abc12345.us-east-1. Find it in Snowflake under Admin → Accounts. For organisation accounts use orgname-accountname.

Getting Started

Guides

Core Concepts

Pipelines

Connectors

Platform

Support

Snowflake Connector

Supported sync modes

How to connect

Step 1 — Create a dedicated Snowflake user

Step 2 — Connect in Zwiron

Finding your account identifier

How Zwiron writes to Snowflake

Schema management

Troubleshooting

​Supported sync modes

​How to connect

​Step 1 — Create a dedicated Snowflake user

​Step 2 — Connect in Zwiron

​Finding your account identifier

​How Zwiron writes to Snowflake

​Schema management

​Troubleshooting

Supported sync modes

How to connect

Step 1 — Create a dedicated Snowflake user

Step 2 — Connect in Zwiron

Finding your account identifier

How Zwiron writes to Snowflake

Schema management

Troubleshooting