ClickHouse

The ClickHouse plugin discovers databases, tables, and views from ClickHouse instances. It extracts schema information, column details, and table metrics like row counts and storage sizes.

Connection Examples

Required Permissions

The user needs read access to system tables:

GRANT SELECT ON system.databases TO marmot_user;
GRANT SELECT ON system.tables TO marmot_user;
GRANT SELECT ON system.columns TO marmot_user;

For read-only discovery of all databases:

GRANT SHOW DATABASES ON *.* TO marmot_user;
GRANT SHOW TABLES ON *.* TO marmot_user;
GRANT SHOW COLUMNS ON *.* TO marmot_user;

name: my-clickhouse-pipeline
runs:
  - clickhouse:
      host: "<host>"
      user: "<user>"