Documentation

Snowflake

IMPORTANT: This article covers setup of warehouse for load data from Improvado, not customer data warehouse from which data is being extracted. This article doesn't cover setup of customer data warehouse for Data Prep as well.

Required information

  • Title
  • Account
  • ~The maximum length is 255 characters
  • User Name
  • Password
  • Database Name
  • ~The maximum length is 255 characters
  • ~Database Name must satisfy the following regular expression: r'^[a-zA-Z_]([\w$])*$'
  • Warehouse
  • ~The maximum length is 255 characters
  • ~Warehouse must satisfy the following regular expression: r'^[a-zA-Z_]([\w$])*$'
  • Schema
  • ~Specify the schema of your database
  • ~The maximum length is 255 characters
  • ~Schema must satisfy the following regular expression: r'^[a-zA-Z_]([\w$])*$'
  • Role
  • ~Role name must satisfy the following regular expression: r'^[a-zA-Z_]([\w$])*$'
  • Use static IP

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 following static IPs only:

  • 34.226.37.150
  • 18.213.72.135
  • 54.146.15.122
  • 3.86.170.178
  • 23.21.191.65

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 above.

How to connect

The following permissions are required:

  • CREATE
  • ALTER TABLE
  • DELETE
  • INSERT

Possible connection errors

  • "SnowflakeSender: Failed to store data to Snowflake – Failed to connect to DB. Verify the account name is correct: ads.snowflakecomputing.com:443. 000403: 403: HTTP 403: Forbidden"

It means there is incorrect format of the account creds.

This example contains the following: `https://ax81240.snowflakecomputing.com`.

The required format is `<account_locator>.<region_id>`, so it has to be something like `ax81240.us-east-1`.

Related articles
No items found.
No items found.