Skip to main content
Snowflake is a cloud data warehouse. MantrixFlow writes to Snowflake using the same connection fields as the source, with additional write permissions.

​
Prerequisites

You need a Snowflake account and a user with write access (INSERT, UPDATE, DELETE, CREATE TABLE) on the target database and schema.

​
Connection Setup

Use the same fields as the Snowflake source: account identifier, warehouse, database, schema, username, and password. Grant the user CREATE TABLE, INSERT, UPDATE, and DELETE on the target schema.

​
Write Modes

​
Append

Inserts new rows into the existing table. The table is created if it does not exist.

​
Replace

Drops and recreates the table on every sync. Full replacement.

​
Upsert

Uses a merge pattern (INSERT + UPDATE) based on the primary key. Specify the upsert key column when configuring the pipeline.