On this page

Before connecting, ensure that you whitelist Fabi.ai’s IP addresses in your firewall or security group settings:

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;

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.