# Ingest Data into ClickHouse

Steup the ClickHouse database, and set username/password to default/public. Taking CentOS as example:

## install dependencies
sudo yum install -y epel-release

## download and run the installation script provided by packagecloud.io
curl -s https://packagecloud.io/install/repositories/altinity/clickhouse/script.rpm.sh | sudo bash

## install ClickHouse server and client
sudo yum install -y clickhouse-server clickhouse-client

## start the ClickHouse server
clickhouse-server

## start the ClickHouse client
clickhouse-client
 
    Copied!
  

Create the test database:

create database test;
 
    Copied!
  

create t_mqtt_msg table:

use test;
create table t_mqtt_msg (msgid Nullable(String), topic Nullable(String), clientid Nullable(String), payload Nullable(String)) engine = Log;
 
    Copied!
  

Create the rule:

Go to the EMQX Dashboard (opens new window), and type in the follwing SQL:

SELECT * FROM "#"
 
    Copied!
  

Select an action:

Add an action and select "Data to ClickHouse" from the dropdown list.

Provide the arguments of the action:

1). The resource id. We create a new clickhouse resource now:

Click "create" right to the resource Id text box, and then select "clickhouse" and fill in the following paramenters:

Click the "Confirm" button.

2). The SQL template. In this example we insert an message to clickhouse:

insert into test.t_mqtt_msg(msgid, clientid, topic, payload) values ('${id}', '${clientid}', '${topic}', '${payload}')
 
    Copied!
  

Keep all other arguments unchanged and confirm the action creation.

Then click "Create" to confirm the rule creation.

Now the rule has been created, we send an testing message to the broker:

Topic: "t/a"
QoS: 1
Payload: "hello"
 
    Copied!
  

And then we can verify if the message is inserted to the clickhouse table: