Snowflake Destination

Updated on Jan 23, 2026

Note: This article covers Snowflake Destination setup process. This guide doesn’t cover the DataPrep setup for Snowflake.

You can learn how to extract data from Snowflake Data source here.

Description

Snowflake is a cloud computing–based data cloud company that offers a cloud-based data storage and analytics service.

Setup guide

Follow our setup guide to connect Snowflake to Improvado.

Permissions

Grant the following permissions:

CREATE
ALTER TABLE
DELETE
INSERT

Complete configuration

On the Snowflake connection page, fill in the following fields:

Enter a name for your Destination connection in the Title.
Enter the Account.

Enter the User Name.
Enter the Database Name.

Enter the Warehouse.

Specify the Schema of your database.

Enter the Role.

Select the necessary Use static IP option from the dropdown.
Upload your Private key .p8 file to the Private Key.

‍(Optional) Enter the Private Key Password.

Select the necessary Use binary strings option from the dropdown.

Additional information

Role

Make sure you use don't use a PUBLIC role because it doesn’t have enough permissions for the load process.

Note: this field cannot be empty.

Use static IP

Select Yes for Use static IP option if you allow Improvado to connect your database by the static IPs mentioned on the Destination connection page.

Select No if you have permitted access to your database from any IP. In this case, Improvado will connect your database using dynamic IPs not listed on the Destination connection page.