Skip to main content

ClickHouse

ClickHouse is a fast, column-oriented database management system that is designed for online analytical processing (OLAP) workloads. It is an open-source project that was created by Yandex, the Russian search engine company. ClickHouse is known for its ability to process large amounts of data quickly and efficiently, making it an ideal solution for big data analytics.

With Illa Cloud, you can deploy and manage ClickHouse clusters on the cloud, without having to worry about the underlying infrastructure and maintenance.

Illa Cloud provides a web-based interface for managing ClickHouse clusters, allowing you to monitor cluster performance, scale resources up or down, and configure backups and security settings. You can also use Illa Cloud to run queries on your ClickHouse data using a web-based query editor.

Create ClickHouse​

There are two ways to create a resource in Illa after signing into your Illa account.

  • Create in Resources

Sign into your Illa account, select **Resources** on the top of the page, and click **Create New** button.

external_resource

Select ClickHouse from the database list.

action_list

Connect to the database with the required parameters described in Connection Settings below.

Click **Test Connection** to see if we can successfully connect to the database. If yes, click Save Resources, else, double check the hostname, port, username, and password is correct.

After creating a resource, the ready ClickHouse will display as shown.

click_config

  • Create in Builder

Sign into your Illa account, create a project in Illa Builder in the **App** page, and navigate to the Action List at the bottom of the page. Click **new**, then select ClickHouse from the database list. Then, connect to the database with required parameters described in Connection Settings below.

Click **Test Connection** to see if we can successfully connect to the database. If yes, click Save Resources, else, double check the hostname, port, username, and password is correct.

Connection Settings​

Here we need to provide information for connecting to ClickHouse database.

click_config

PropertiesRequiredDescription
NamerequiredThe name for resource when creating actions in the ILLA.
HostnamerequiredThe URL or IP address for your database
PortrequiredThe server host's port number that you should use to connect. If you don't specify a port, default port is '9440'.
DatabaserequiredThe name of the database
Usernamerequiredthe username you wish to use when logging in to the ClickHouse server.
PasswordrequiredUse this password for authentication.
SSL optionsoptionaldecides how high a secure SSL TCP/IP connection is prioritized while negotiating with the server.

Create Actions​

We have created a ClickHouse resource, we can add the action by selecting ClickHouse from action list and choosing the Create action button.

click_resource_list

Now we have added the ClickHouse server as an action to our building page.

click

Configure ClickHouse​

PropertiesDescription
SQL querysql commands to fetch (select), insert, update, delete data from database
Transformertransforming data into the style you like using JavaScript

Example usage:

  • Select
SELECT * FROM users ORDER BY lastname;
  • Insert
INSERT INTO users

    (firstname, lastname, email)

VALUES

    (

        {{ NewUser.data.firstNameInput }},

        {{ NewUser.data.lastNameInput }},

        {{ NewUser.data.emailInput }}

    );
  • Update
UPDATE users
  SET firstname = '{{form1.updatedProfile.first}}'
  WHERE id = {{ form1.updatedProfile.uid}};
  • Delete
DELETE FROM users WHERE id = {{ form1.updatedProfile.uid }};