Documentation

Clickhouse

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
  • Host
  • Port
  • User Name
  • ~The maximum length is 63 characters
  • Password
  • Database Name
  • ~Database Name can only contain letters, numbers and underscores. It must start with a letter and cannot end with an underscore
  • ~The maximum length is 63 characters
  • Interface
  • ~native
  • ~http
  • ~https
  • 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:

  • SELECT
  • CREATE TABLE
  • CREATE TEMPORARY TABLE
  • S3
  • INSERT
  • ALTER COLUMN
  • ALTER DELETE
  • TRUNCATE
  • DROP TABLE
Related articles
No items found.
No items found.