Connect to Snowflake

Overview

Connect to Snowflake via Matillion Data Loader and use it as your destination for batch-loading a pipeline.

ACCOUNTADMIN role privileges in Snowflake, or privileges equivalent to the SECURITYADMIN and SYSADMIN roles.

Read Set up Snowflake for more information.

Property	Description
Destination label	A name for the destination.
Account	Your Snowflake account. Your account might contain the name, region, and cloud provider.
Username	Your Snowflake username.
Password	Select a saved password from the drop-down menu. This should be your Snowflake login password.
Advanced Settings	Additional JDBC parameters or connection settings. Click Advanced settings and then choose a parameter from the dropdown menu and enter a value for the parameter. Click Add parameter for each extra parameter you want to add.

Click Test and continue to test your settings and move forward. You can't continue if the test fails for any reason.

Set up the Snowflake destination. Your login connection to Snowflake affects which roles, warehouses, databases, and schemas you can choose.

Property	Description
Role	An entity with privileges. Read Overview of Access Control to learn more.
Warehouse	A Snowflake warehouse. Read Overview of Warehouses to learn more.
Target database	A Snowflake database. Read Database, Schema, and Share DDL to learn more.
Target schema	A Snowflake schema to load the table into. Read Database, Schema, and Share DDL to learn more.
Table prefix	Add an optional prefix to your destination table. This field is empty by default.

Click Test and continue to test your settings and move forward. You can't continue if the test fails for any reason.

Table of contents