Clickhouse Database
-
Prerequisites: Obtain the database host, port, and credentials (username and password) with read access to the databases you want to query.
-
Configuring Doctor Droid: Go to Integrations > Clickhouse in the Doctor Droid dashboard. Enter your database connection details.
-
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.
To restrict permissions to the users accessing CH via Doctor Droid, we recommend creating a custom role with the minimal permissions to get the relevant data. Here are 3 queries that you can run in your CH query console to create a new account:
Create a new user:
CREATE USER 'doctordroid' IDENTIFIED BY '%9v3vdsboq3v5Nyn5I';
Give required permissions to the user:
GRANT SELECT ON db_name.table_name TO 'doctordroid';
Verify permissions granted:
SELECT \* FROM system.grants WHERE user_name = 'doctordroid';
Updated about 1 month ago