​

Connection:

​

Step 1: Go to Integrations > Clickhouse in the Playbooks platform.

​

Step 2: Enter your database connection details. (database host, port, and credentials (username and password))

Note: When you fill in the host, you do not need to add https://.

​

Step 3: Testing the Integration: Create a playbook that includes a step to run a simple SELECT query against your Clickhouse database and verify the results are fetched correctly.

​

Querying:

After adding Clickhouse DB as a connection, you can do the following:

• Run a query on Clickhouse DB.

​

How to limit access to select tables/DBs within Playbooks?

To restrict permissions to the users accessing Clickhouse via Playbooks, we recommend using roles that are relevant for

​

Create a new user:

CREATE USER 'new_user_name' IDENTIFIED BY '%9v3vdsboq3v5Nyn5I';

​

Give required permissions to the user:

GRANT SELECT ON db_name.table_name TO 'new_user_name';

​

Verify permissions granted:

SELECT \* FROM system.grants WHERE user_name = 'new_user_name';