Clickhouse Database

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';