ClickHouse

Overview

Mitzu connects to ClickHouse by using username/password authentication.

warning

If the ClickHouse is hosted by you then please make sure the 99.81.21.134 ip is allowed inbound traffic to the specified port.

Supported data types

Mitzu will map the types of the data warehouse based on the following table:

Mitzu type	Data warehouse type
String	String, FixedString
Number	UInt8, UInt16, UInt32, UInt64, UInt128, UInt256, Int8, Int16, Int32, Int64, Int128, Int256, Float32, Float64
Boolean	Boolean
Datetime	Date, Date32, DateTime, DateTime64
Map	Map
Struct	Tuple
Array	Array

info

All unrecognized types will be handled as strings.

Configure the connection details in Mitzu

Please fill out the form with the details of your connections.

For an encrypted connection, please use the port number 9440 and check the Secure connection (SSL) checkbox. For an unencrypted connection (not recommended), use the port 9000.

note

When entering URLs in our system, please include only the "Host" portion, omitting the protocol scheme like https.

You can configure the connection query parameters. To do so, click on theAdvanced settings section and enter your parameters into theURL Query Params textbox. You must write each parameter in a new line in the <parameter name>=<parameter value> format.

Click the Test connection button to check if Mitzu can connect to your data warehouse using the entered values.

warning

Mitzu will try to connect to your data warehouse and execute a SELECT 1;command. You may need to grant further permission Mitzu to see and query your data tables.

To save the settings, click the Test connection & Save button.

Next steps

Once the connection is tested an saved the event end dimension tables can be configured. Please follow the setting up event tables guide.