ClickHouse

1. Create a dedicated user

What: Create a non-human ClickHouse user for Querio.

CREATE USER querio_user IDENTIFIED BY 'STRONG_PASSWORD';

Use a long random password and store it securely.

2. Grant read-only access

What: Give Querio read access to the database it should query.

GRANT SELECT ON my_database.* TO querio_user;

Repeat grants for each database Querio should access. For tighter access, grant permissions on specific tables.

3. Share connection details

Provide:

• Host
• Port, usually 9440 for secure native connections
• Username
• Password
• Database