ClickHouse

1) Create a dedicated ClickHouse user

What: A non-human account used only by Querio, with least-privilege access.

How (run as a user with admin privileges):

Execute the following SQL against the DB

-- Replace 'querio_user' and 'STRONG_PASSWORD' as needed
CREATE USER querio_user IDENTIFIED BY 'STRONG_PASSWORD';

Tip: Use a long, random password (at least 16 characters) — a password manager can generate one.

2) Grant read-only access to the required database

What: Limit Querio's access to only the data it needs.

How (example for my_database):

Execute the following SQL against the DB

-- Database access
GRANT SELECT ON my_database.* TO querio_user;

Repeat grants for each database Querio needs to query. For specific table access, use: GRANT SELECT ON database.table_name TO querio_user;

3) Collect and share the connection details

What: These are the connection parameters Querio will use to connect to your ClickHouse database.

Required values:

• Host: The address of your ClickHouse database (hostname or IP address)
• Port: The port used for secure native connections to your ClickHouse database. This is usually 9440 (see ClickHouse documentation)
• Username: querio_user (or whatever you created)
• Password: The one you set in CREATE USER
• Database: The database Querio should query

Note: Port 9440 is the default for secure native protocol connections. If your ClickHouse instance uses a different port, check your server configuration.