Snowflake

Overview

Use Snowflake as a destination in Mage to load structured data into your cloud data warehouse. Mage supports both row-by-row insertion and batch upload modes, and integrates with Snowflake using username/password or key-pair authentication. This destination is ideal for exporting transformed pipeline data for analytics, BI tools, or data lakehouse modeling.

Required Configuration

Provide the following credentials when configuring Snowflake as a destination:

Key	Description	Example Value	Required
`account`	Your Snowflake account identifier.	`abc1234.us-east-1`	✅
`database`	Name of the Snowflake database to write to.	`DEMO_DB`	✅
`schema`	Schema within the database where the table will be created.	`PUBLIC`	✅
`table`	Target table that Mage will create or insert into.	`dim_users_v1`	✅
`username`	Snowflake user with `INSERT` and `CREATE TABLE` permissions.	`guest`	✅
`warehouse`	Virtual warehouse used to execute queries and ingest data.	`COMPUTE_WH`	✅
`use_batch_load`	If `true`, enables batch loading instead of row-by-row inserts. Recommended for performance.	`true` (default)	✅
`disable_double_quotes`	If `true`, column and table names will not be wrapped in double quotes. Disabling may reduce case-sensitivity issues.	`false` (default)	✅

Optional Connection Parameters

Key	Description	Example Value
`password`	Password for the Snowflake user.	`abc123...`
`private_key_file`	Path to the private key file for key-pair authentication (requires version ≥ 0.9.76).	`/path/to/key.p8`
`private_key_file_pwd`	Passphrase for the private key file.	`abc123...`
`role`	Snowflake role to use for the session.	`ANALYST_ROLE`

🔐 Enable key-pair authentication →

Optional Mage Settings

Key	Description	Example Value
`skip_schema_creation`	If `true`, Mage will skip running the `CREATE SCHEMA` command. Useful if the schema already exists. See issue	`true`
`lower_case`	If `true`, Mage will convert all column names to lowercase. Default is `true`.	`true`

Notes

Set use_batch_load: true for large datasets to improve performance and reduce API calls.
When using key-pair authentication, ensure the private key is generated and stored securely.
If disable_double_quotes is false, column names will retain their case. Otherwise, names will be treated as case-insensitive.
Make sure your user has permission to create tables and write to the specified schema in the selected database and warehouse.

Adventure starts here

Concepts

Project

Contributing

About

Overview

Required Configuration

Optional Connection Parameters

Optional Mage Settings

Notes

​Overview

​Required Configuration

​Optional Connection Parameters

​Optional Mage Settings

​Notes

​Related Resources

Overview

Required Configuration

Optional Connection Parameters

Optional Mage Settings

Notes

Related Resources