Connect to Snowflake
Connect to Snowflake via Data Loader and use it as your destination for batch-loading a pipeline.
Prerequisites
ACCOUNTADMINrole privileges in Snowflake, or privileges equivalent to theSECURITYADMINandSYSADMINroles.
Read Set up Snowflake for more information.
Connect to Snowflake
| 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.
Configure Snowflake
Set up the Snowflake destination. Your login connection to Snowflake affects which roles, warehouses, databases, and schemas you can choose. The connection settings will vary if you are using a Custom Connector.
| 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. |
| Cloud Credential | Add appropriate cloud credentials to access the staging location, if required. Only applicable to custom connectors. |
| Staging location | Select an appropriate staging location for the pipeline data. Only applicable to custom connectors. |
| 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.