Snowflake Connector

Live — enterprise connector. Fully supported today (SAT-validated). One of Zwiron’s five production connectors: PostgreSQL, MySQL, MongoDB, Snowflake, BigQuery.

Snowflake is a cloud data warehouse built for analytics. You can use it as a destination to load data from databases, APIs, and files, or as a source to read from existing tables.

Supported sync modes

As destination	Write modes
	Append, Upsert, Replace

As source	Full Refresh	Incremental
	✅	✅

How to connect

You can connect Zwiron to Snowflake using OAuth (recommended) or username + password.

OAuth (recommended)
Username + Password

OAuth lets you connect without storing a password — you authorise Zwiron directly from your Snowflake account.

Step 1 — Create a Security Integration in Snowflake

A Security Integration is Snowflake’s term for an OAuth app. You need to create one inside your Snowflake account so Zwiron can request access on your behalf.Open a Snowflake worksheet and run:

CREATE SECURITY INTEGRATION zwiron_oauth
  TYPE = OAUTH
  ENABLED = TRUE
  OAUTH_CLIENT = CUSTOM
  OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
  OAUTH_REDIRECT_URI = 'https://api.zwiron.com/v1/oauth/callback'
  OAUTH_ISSUE_REFRESH_TOKENS = TRUE
  OAUTH_REFRESH_TOKEN_VALIDITY = 7776000;

You need the ACCOUNTADMIN role to create Security Integrations.

Step 2 — Get your client ID and secret

SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('ZWIRON_OAUTH');

This returns a JSON object. Copy the values of OAUTH_CLIENT_ID and OAUTH_CLIENT_SECRET — you’ll need them in the next step.

Step 3 — Add the credentials to Zwiron

Contact your Zwiron administrator to set the following environment variables for your workspace:

OAUTH_SNOWFLAKE_CLIENT_ID=<your client ID>
OAUTH_SNOWFLAKE_CLIENT_SECRET=<your client secret>

Step 4 — Find your account identifier

You must provide your account identifier to start OAuth. Unlike providers such as GitHub, Snowflake has no single global login URL — every customer has their own dedicated server (e.g. ym34109.ap-southeast-1.snowflakecomputing.com). Zwiron needs to know which server to open the OAuth popup for before the login can begin. There is no way to discover this automatically.Your account identifier is the subdomain from your Snowflake login URL — including the region.

Your Snowflake URL	Account identifier to enter
`https://ym34109.ap-southeast-1.snowflakecomputing.com`	`ym34109.ap-southeast-1`
`https://xy12345.us-east-1.snowflakecomputing.com`	`xy12345.us-east-1`
`https://myorg-myaccount.snowflakecomputing.com`	`myorg-myaccount`

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

SELECT CURRENT_ACCOUNT(), CURRENT_REGION();

Or go to Admin → Accounts in the Snowflake UI — hover your account name to copy the full identifier.

Always include the region (e.g. ym34109.ap-southeast-1, not just YM34109). Using the short ID without the region will result in a 404 error when the OAuth popup opens.

Step 5 — Connect in Zwiron

Go to Connections → Add Connection → Snowflake
Enter your Account identifier (e.g. ym34109.ap-southeast-1)
Click Sign in with Snowflake
A Snowflake login popup opens — sign in and approve the access request
Zwiron fills your credentials automatically
Fill in Database and Warehouse in the form
Click Test Connection to verify, then Next to save

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`
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

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)

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.

'This integration is not enabled' error

Run ALTER SECURITY INTEGRATION zwiron_oauth SET ENABLED = TRUE; in Snowflake.

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 Security Integration in Snowflake

Step 2 — Get your client ID and secret

Step 3 — Add the credentials to Zwiron

Step 4 — Find your account identifier

Step 5 — Connect in Zwiron

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 Security Integration in Snowflake

​Step 2 — Get your client ID and secret

​Step 3 — Add the credentials to Zwiron

​Step 4 — Find your account identifier

​Step 5 — Connect in Zwiron

​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 Security Integration in Snowflake

Step 2 — Get your client ID and secret

Step 3 — Add the credentials to Zwiron

Step 4 — Find your account identifier

Step 5 — Connect in Zwiron

Step 1 — Create a dedicated Snowflake user

Step 2 — Connect in Zwiron

Finding your account identifier

How Zwiron writes to Snowflake

Schema management

Troubleshooting