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';
Updated 6 months ago