ClickHouse

Connecting DinMo to ClickHouse: Step-by-Step Guide

Go to the workspace settings, then to the Source tab, and click "Add New Source".

• Step 1: Select ClickHouse from the list of available sources

• Step 2: Create a DinMo user on your DataWarehouse and the DinMo technical datasets. DinMo needs to read all the tables that you want to use to build models and segments. It also needs to write access to a database that will be used to store technical data (segment queries, segment stats, activation snapshots).

  We recommend you create a specific user and role for DinMo and grant them the needed permissions.

  You can do so by running the following SQL snippet.

-- Create the technical database that DinMo will use to store its internal data
CREATE DATABASE IF NOT EXISTS dinmo_technical_data;

-- Give the DinMo user the ability to sign in with a password
CREATE USER IF NOT EXISTS DINMO_USER IDENTIFIED WITH bcrypt_password BY '<strong, unique password>';
CREATE ROLE IF NOT EXISTS DINMO_ROLE;
GRANT DINMO_ROLE TO DINMO_USER;

-- Let the DinMo Role read and query the database that contains the data that you want to use in the DinMo Platform
-- You can have fine-grained access control by granting permissions only on specific tables or views instead of the whole database
-- Replace <your database> with the name of the database where you store the tables and views that will be used in the DinMo Platform
GRANT SELECT ON <your database>.* TO DINMO_ROLE;

-- Grant the DinMo Role full access to the technical database
GRANT SELECT ON dinmo_technical_data.* TO DINMO_ROLE;
GRANT CREATE, DROP TABLE ON dinmo_technical_data.* TO DINMO_ROLE;
GRANT CREATE, DROP VIEW ON dinmo_technical_data.* TO DINMO_ROLE;
GRANT INSERT ON dinmo_technical_data.* TO DINMO_ROLE;

Please edit the <value> fields in the script to define your own credentials and parameters.

• Step 3: Fill in the required information

  • Url: The url or IP address.

  • Database: The name of the database.

  • Port: The port number. The default is 8443, but yours may be different.

  • User and password: The credentials you created in the script above.

• Step 4: Hit "Save & Test". This will launch a test ensuring that the connection is working. If so, congratulations, your source setup is finished!

---

If you encounter an error or question not listed below and need assistance, don't hesitate to reach out to your account manager or [email protected]. We're here to help!