ClickHouse

Allow access

Create a rule in a security group or firewall settings to allowlist:

1. Incoming connections to your host and port (usually 9440) from the static IP.
2. Outgoing connections from ports 1024 to 65535 to the static IP.

Create writer user

Create a database user to perform the writing of the data.

1. Open a connection to your ClickHouse database.

2. Create a user for the data transfer by executing the following SQL command.

   1
   CREATE USER <username>@'%' IDENTIFIED BY '<some-password>';
   Password Rules

   Passwords may only include alphanumeric characters (A-Z, a-z, 0-9), dashes (-), and underscores (_).

3. Grant user required privileges on the database.

   1
   GRANT SELECT ON information_schema.columns TO <username>;
   2
   GRANT CREATE, INSERT, DROP, ALTER, OPTIMIZE, SHOW, TRUNCATE ON <database>.* TO <username>@'%';
   3
   grant CREATE TEMPORARY TABLE, S3 on *.* to <username>@'%';
   Understanding the CREATE TEMPORARY TABLE, S3 permissions

   The CREATE TEMPORARY TABLE and S3 permissions are required to efficiently transfer data to ClickHouse. Under the hood, these permissions are used to stage data in object storage as compressed files, COPY INTO temporary tables, and finally merge into the target tables. By definition, the temporary table will not exist outside of the session.

Set up staging bucket

ClickHouse destinations require a staging bucket to efficiently transfer data. Configure your staging bucket using one of the following types of ClickHouse supported object storage:

• S3
• GCS
• Implicit

Add your destination

Use the following details to complete the connection setup: host name, port, cluster, database name, schema name, username, password, and staging bucket details.

• Instructions for Analyze / Optimize for Webflow sites
• Instructions for Optimize for non-Webflow sites