​

1. Connect to ClickHouse as an admin user

clickhouse-client --user default --password

Enter your admin password if prompted.

​

2. Create a new user

Replace service_user and secret_password with your chosen name and password:

CREATE USER service_user IDENTIFIED BY 'secret_password';

Grant Read Permissions: If you have a database called my_database, run:

GRANT SELECT ON my_database.* TO service_user;

​

Connecting ClickHouse to Fabi.ai

Once you’ve generated your service user credentials, follow the steps in Connecting to Your Data