ClickHouse

Documentation Index

Fetch the complete documentation index at: https://artie.com/docs/llms.txt

Use this file to discover all available pages before exploring further.

​

Required settings

• Warehouse Address (for “Connect with:”, select “Go”, then copy the address highlighted in the image below)
• Service account username
• Service account password

​

Creating a service account

CREATE USER artie IDENTIFIED BY 'password';

GRANT CURRENT GRANTS ON *.* TO artie;

-- To be extra secure, you can also restrict the user to specific databases that they can see.
-- For example, this will exclude the service account from being able to see the "default" database.
REVOKE ALL ON default.* FROM artie;

​

Retrieving the warehouse address