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
For information about our industry-leading security practices, check out our Security hub.