Documentation

Note: Snowflake is currently supported only as a Destination. This guide doesn’t cover the DataPrep setup for Snowflake.

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:

1. Enter a name for your Destination connection in the Title.
2. Enter the Account. {%dropdown-button name="account"%}

{%dropdown-body name="account"%}

• If you have a non-VPS Snowflake Edition and your account is not located in a default US West (Oregon) region, then you must use Account Identifier according to the list: Account identifiers | Snowflake Documentation. E.g., ```{account_locator}.eu-west-2.aws``` for Europe (London) region.
• The maximum length is 255 characters

{%dropdown-end%}

3. Enter the User Name.
4. Enter the Password.
5. Enter the Database Name. {%dropdown-button name="database-name"%}

{%dropdown-body name="database-name"%}

• The maximum length is 255 characters
• Database Name must satisfy the following regular expression: ```r'^[a-zA-Z_]([\w$])*$'```

{%dropdown-end%}

6. Enter the Warehouse. {%dropdown-button name="warehouse"%}

{%dropdown-body name="warehouse"%}

• The maximum length is 255 characters
• Warehouse must satisfy the following regular expression: ```r'^[a-zA-Z_]([\w$])*$'```

{%dropdown-end%}

7. Specify the Schema of your database. {%dropdown-button name="schema"%}

{%dropdown-body name="schema"%}

• The maximum length is 255 characters
• Schema must satisfy the following regular expression: ```r'^[a-zA-Z_]([\w$])*$'```

{%dropdown-end%}

8. Enter the Role. {%dropdown-button name="role"%}

{%dropdown-body name="role"%}

Role name must satisfy the following regular expression: ```r'^[a-zA-Z_]([\w$])*$'```

{%dropdown-end%}

9. Select the necessary Use static IP option from the dropdown.
10. Select the necessary Use binary strings option from the dropdown. {%dropdown-button name="use-binary-strings"%}

{%dropdown-body name="use-binary-strings"%}

The "Use binary strings" determines whether string fields are encoded in binary format when loading data.

Recommended setting: "No" (default).

{%dropdown-end%}

‍

Additional information

Role

The ```SYSADMIN``` role should be granted to the specified user. Make sure you use not 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.